getting partial info in a query to work...

[immaxx]

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?

thx.

[Rabbit]

In the criteria for the field you want to filter, put:

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.

[immaxx]

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?

[Rabbit]

Someone else will have to answer that question. My Access has never done that.

[immaxx]

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

thx again for the query script.

[Rabbit]

Not a problem.