Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do i make it so that no input returns all

Status
Not open for further replies.
KaayJaay

KaayJaay

IS-IT--Management
Jul 6, 2004
64
US
Im trying to make it so that if a user doesnt kno what they are looking for exactly, that they can not enter anything or enter something that will return all records.

KaayJaay
 
Sort by date Sort by votes
Take a look at the Like operator (the * wildchar)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mhshane
  • Question
Is this the best way to do this query?
Replies
5
Views
176
Andrzejek
Andrzejek
breezett93
  • Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
8
Views
588
breezett93
breezett93
accesshelp1
  • Locked
  • Question
How can I remove parenthesis and everything that comes after it? 1
Replies
3
Views
1K
Andrzejek
Andrzejek
breezett93
  • Locked
  • Question
Brand new lock violations errors all over my database
Replies
11
Views
5K
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Can not get Access 2016 queries to accept form value input or TempVars! input 2
2
Replies
21
Views
2K
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top