multifield keyword search

[georgvh]

HI, Im trying to create a keyword search based on the data in several fields. The below command works well for searching one field, but I want to search several at once. Any help would be great. Thanks!

What you need is a parameter query. In the criteria space in the desired field in your query, put the following: Like "*" & [Search by word:] & "*"

When you run the query, a message box will pop up that says "Search by word:", and then you could type in "mountain" or "goat" or even just type in one or two letters. To make it more/less specific, play around with those wildcards.

 

[MStef]

Hello Georg!

Look at "DemoMultiSearchA2000.mdb", I think it can help you.
Look at Table1,Form1 (VBA), Report1 (VBA), Module1.
Open Form1 and try.

 

[georgvh]

Help! (again)

Hi,
Thanks for your reply Stef...unfortunately I didn’t get what your example was trying to show me, so I’m still stuck!

I'll try and explain the set up...
The database is for a video collection. I want to have ONE search box that will look for a match in any of the following fields:
-Tape title
-Film1
-Film2
-Keywords
-Notes

Any ideas anyone? I would be very grateful if anyone can help

Thanks!

 

[MStef]

Hello Georg!

OK, I know what you need, but it is a biger job, I'll try to construe something.

 

[MStef]

Hello Georg!

Here it is, I think it is what you need.
Open Form1SELECTION an try.

 

[MStef]

Adapt it for your task.