Multiple inputable criteria query

[DJ-Specter]

Hi, I have different buttons on a form that search for specific individual profile types i.e. age range 16-24, gender male/female, disability, ethnicity etc where each button brings up forms detailing all people conforming to that specific criteria.

What I need to do is create a mechanism, probably a query of some kind, that allows a user to input multiple criteria i.e. all female clients between the ages of 25-34 who are Asian, and have it bring up a form listing all conforming clients.

Any ideas would be massively appreciated.

Thanks

 

[ajetrumpet]

create an input form then query it out based on the inputs they give you. the param poipup from the qry builder is coimpletely pointless.,

 

[dcb]

Are you using parameter queries for the buttons?

You can create a form as a query control with combo boxes that have lists of criteria that control a query. If you then used this query as a source for the form you would have the desired result

Search for
Parameter Query
Criteria
In Help

As Adam says:

 

[DJ-Specter]

create an input form then query it out based on the inputs they give you. the param poipup from the qry builder is coimpletely pointless.,

What is an input form? is it something that only appears on versions after 2003? just as that is the version i am limited to unfortunately.

The point of the system i am trying to create is to have an easy to use interface for people so they don't have to involve themselves with any of the inner workings.

 

[ajetrumpet]

What is an input form? is it something that only appears on versions after 2003? just as that is the version i am limited to unfortunately.

The point of the system i am trying to create is to have an easy to use interface for people so they don't have to involve themselves with any of the inner workings.

htat's the point of completing a database at all dude! at least you're on the right track. I'm using "10 year old" shorthand language when I talked, so sorry you did nt get it.

in general....

MAKE A FORM
PUT BOXES ON IT
TELL USERS "FILL IN THESE BOXES BASED ON WHAT YOU WANT TO SEE"
THEN WRITE A QUERY WITH PARAMS that are those form controls, not annoying popup boxes. ANNY BETTER ? FOLLOW?

 

[DJ-Specter]

htat's the point of completing a database at all dude! at least you're on the right track. I'm using "10 year old" shorthand language when I talked, so sorry you did nt get it.

in general....

MAKE A FORM
PUT BOXES ON IT
TELL USERS "FILL IN THESE BOXES BASED ON WHAT YOU WANT TO SEE"
THEN WRITE A QUERY WITH PARAMS that are those form controls, not annoying popup boxes. ANNY BETTER ? FOLLOW?

nice one, sorry man - i've litterally had to learn access in like two weeks so i've got loads to learn still so cheers for helping me.

i know how to do all the stuff you said up till the query with paramaters that are the form controls - do i have to enter some code into the criteria box the this stage? i saw something like [form]![formname]! and then something else following that in an example somewhere. am i on the right lines?

i litterally have no experience with the code aspect of access so i've been trying to do as much as i can with the wizard but i get the feeling you get alot more control over everything if you do it manually? also, to include multiple criteria should i just use multiple [form]![formname] etc separated by 'and' statements?

nice one, thanks again

 

[dcb]

i litterally have no experience with the code aspect of access so i've been trying to do as much as i can with the wizard but i get the feeling you get alot more control over everything if you do it manually? also, to include multiple criteria should i just use multiple [form]![formname] etc separated by 'and' statements?

Your on the right track: also lookup IsNull using it something like - =Forms![FormName].[FieldName] or Forms![FormName].[FieldName] IsNull
Something like this : I havent done this in a while but I do remember the frustration when it didnt work - basically you use this so that the users can leave one of the boxes not filled in and not filter by that field...

Try Pressing Ctrl+F2 while you are in the criteria field

Good Luck

 

[ajetrumpet]

nice one, sorry man - i've litterally had to learn access in like two weeks so i've got loads to learn still so cheers for helping me.

i know how to do all the stuff you said up till the query with paramaters that are the form controls - do i have to enter some code into the criteria box the this stage? i saw something like [form]![formname]! and then something else following that in an example somewhere. am i on the right lines?

i litterally have no experience with the code aspect of access so i've been trying to do as much as i can with the wizard but i get the feeling you get alot more control over everything if you do it manually? also, to include multiple criteria should i just use multiple [form]![formname] etc separated by 'and' statements?

nice one, thanks again

other people have stepped in and are helping you. if you want a example, pm me and I'll show you what I meanbt, OK>??

 

[DJ-Specter]

I'm going to try and use toggle buttons as inputs for the criteria - can i use them to toggle a code snippet to be inputted into a blank query? cheers