By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,207 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

getting partial info in a query to work...

P: 3
im extremely new at this so you know.

i managed to build a part database for the repair shop i work for and the mech's here know even less than i do.

i've set up 2 queries, one by part number, and one by type. i want them both to grab partial results.

for instance, if they type in "ms4" in the part # query, i want ms4332a to show as well as 997ms4....

and on part type, if they type "valve", i want all the valves to show up in the result along with all the tube valves.

what do i put in the query in design or in the expression builder to get this to happen?

Feb 13 '07 #1
Share this Question
Share on Google+
5 Replies

Expert Mod 10K+
P: 12,366
In the criteria for the field you want to filter, put:
Expand|Select|Wrap|Line Numbers
  1. Like "*" & [Search String] & "*"
This will bring up an input box when they run the query asking them to define what [Search String] is equal to. The asterisks are wildcards.
Feb 13 '07 #2

P: 3
thx that worked great...

here's my bonus ?...

i created 2 shortcuts for the desktop, 1 for each query.

is there any way to get past the little song and dance questionairre stuff when you open access, like "do you want to block unsafe expressions" and just have the little query dialog box open right up?
Feb 13 '07 #3

Expert Mod 10K+
P: 12,366
Someone else will have to answer that question. My Access has never done that.
Feb 13 '07 #4

P: 3
i figured it out, it was in the security section of macros...

thx again for the query script.
Feb 13 '07 #5

Expert Mod 10K+
P: 12,366
Not a problem.
Feb 13 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.