Code:
SELECT Users.[Actor Name],
Last_Name & First_name AS Fullname,
Users.LAST_NAME,
Users.FIRST_NAME,
Users.Status,
Users.Email,
Users.IS_LOCKED,
Users.Description
FROM Users
SachinPatel
Last Activity: Oct 15 '09, 02:30 PM
Joined: May 21 '09
Location:
-
I have used a combo box and created sql in the Row source to bring the fields required from the users table back to that box.(as below)
... -
the funny thing is i have no text in the change event of the input box
Just to confirm by input box you mean the combo box where i enter the username or the text box that i would like to see the similar username results listed ?
For the combo box (username) i have sql in the row souce
for the text box (username matches) i currently have a non working sql query.
??Leave a comment:
-
Chip,
Attached sample database.
If you look at the form (issueslog) the user will need to select one of the option groups first then the Username combo box becomes enabled.
Once enabled the user can start typing in a name based on the option group selection and whilst typing in a name i would like the list box to the right (Username Matches) to show all the suers that match the name
for...Leave a comment:
-
Radio Button Problem
ChipR,
Good news i have figured the radio button issues out with some SQL and some VBA functions.
Thanks for you support.
I am still trying to diaplay all macthing types in the list box (Username Matches....) to the names i insert in the username combo box.
any ideas? please see below for the names of each object .
What i am trying to to is one a user selects active / inactive or All,... -
sorry - its not that i have foudn the way to get the heading as modules and still not referring to module!Leave a comment:
-
just noticed when i create my module i comes under the heading unrelated objects while yours comes under the modules heading - this could be the reason?
if so how can i do it so it looks like yours and comes under modules heading?Leave a comment:
-
Hey Adezii
thanks for that - wheni open the attachment i get error message saying macros action failed - should this happen?
also i looked at VB and still unable to confirmi if i am correctly creating a public function my SQL query can reference.
NeoPa - apologise for the misunderstandin g of how these forums work!Leave a comment:
-
hey ADezii,
just seeing if you had chance to send over how to make a vba function public and refer toit on the sql you created without getting an error message.
ThanksLeave a comment:
-
thanks mate your a life saver - i will log on later (5 hours or so)
thanks again your a star!Leave a comment:
-
Sorry mate - i believe i am defining the item as public, however as this is new to me maybe i am doing it wrong- can you possible tell me the correct way to define the function as public in a standard code module?Leave a comment:
-
ADezil,
sorry to bother you buti have doneas you stated above however when i try run the query i am getting the error message as follows:
Undefined Function 'fCalculatePerc entiles' in expression
is there a certain way i shouldbe saving the VBA code to ensure the query can refer to it?Leave a comment:
-
Percentile Usage
ADezii,
i have been reading your solution to this percentile problem and believe you can help me.
I have a similar problem with creating a percentile in access 2007.
My table is called "TBL_DATA" and the field with all the values i would like to gain a percentile for is called "DAYS"
i want to develop a query which shows the following columns
- Min Days...
No activity results to display
Leave a comment: