Query promting for search criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I need my query to prompt the user to type what they are looking for as
criteria. I have done this before by typing the message for the criteria
promt in speach marks such as: "Please Type Name" but this doesnt work i
think i need to type a word before it but i cant remember what it is, does
any one know?
 
Or to find anywhere in the field...

Like "*" & [please type partial name] & "*"

This will also allow them to leave it blank for "all".
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form with a combo box doesn't run in Query 2
Access Dcount (multiple criteria) 3
Why can't I copy/paste criteria into parameter query box? 2
Parameter Query multiple criteria help 6
Use a parameter prompt with a crosstab query 4
search multiple criteria 0
Parameter Query mm/yyyy 1
Use In() Expression as Query criteria with guts from Function 1

Back
Top