parameter prompt help

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

HI,

Can any on tell me how I can create a parameter prompt
that can except multiple entries for example;

PROMPT would be Enter Funds
the user could type in one fund 111 or type in fund 222
555 667 888 999 so only that or those funds or what ever
they type in get pulled.

Thanks
 
In the query criteria line, type [fund1]or[fund2]or[fund3]
or[fund4]or......[fundk] Enter as many [fund#] as you
think someone will need. The only problem is that the
user will be prompted for all the [] even if they just
want to look at 1 fund. of course they can just click ok
to bypass them. I might recommend using a form with combo
boxes where the user can enter what funds they want
without having to be prompted for each one.
 
I am no expert... but here is what I use to find specific records in my
query.

Like [Enter: Position Applied For] & "*"

This is in the Criteria field in my query. When I open the query it
prompts me to enter my search criteria, such as: Engineer or Accountant or
if I tab through the prompt it gives me all the records in my database!

Hope this helps

Although, I have not figured out how to have Access present me with a
drop-down list of the current items in the field that I could just pick
from? That would be kewl, if someone knew how to do that!
_____
Rohn Everson
Yahoo messenger: (e-mail address removed)
http://groups.yahoo.com/group/MMQB
 
Ron, to have the drop down list you desire do the
following. 1.) Create a blank unbound form. 2.)in
design view of the new form add a combo box. The combo
box wizard will run and you'll have an option to type in
the values you want to choose from or you can link it to
the table/field that contains Accountant/Engineer, etc.
3.)Go back to the your query and where you typed "Like
[Enter: Position Applied For] & "*", instead type:
[forms]![frmname]![cbo#]
Add a button to your form that runs this query. The new
criteria will look to that form's combo box for the
parameter.
-----Original Message-----
I am no expert... but here is what I use to find specific records in my
query.

Like [Enter: Position Applied For] & "*"

This is in the Criteria field in my query. When I open the query it
prompts me to enter my search criteria, such as: Engineer or Accountant or
if I tab through the prompt it gives me all the records in my database!

Hope this helps

Although, I have not figured out how to have Access present me with a
drop-down list of the current items in the field that I could just pick
from? That would be kewl, if someone knew how to do that!
_____
Rohn Everson
Yahoo messenger: (e-mail address removed)
http://groups.yahoo.com/group/MMQB


HI,

Can any on tell me how I can create a parameter prompt
that can except multiple entries for example;

PROMPT would be Enter Funds
the user could type in one fund 111 or type in fund 222
555 667 888 999 so only that or those funds or what ever
they type in get pulled.

Thanks
Click to expand...

.
Click to expand...
 
Back
Top