Better search plugin/macro?

[iddqd]

Not sure where to post it, though what I have in mind is similar to a query.

Basically, I want it to look like a web search engine.

You know, you enter a search phrase, and it returns a list of results where it finds matches.

So, just like that, I want it to search through a table and return all the entries where it found a match in a query. I think someone must have wrote something like this by now. Anyone know where I can find the code?

 

[grnzbra]

How about creating a set of global variables and matching functions to read them. Then the inputs from the form are moved to the corresponding variables which would be read by the functions. If the variable was empty, the function would be set to "*". If it were not empty, it would be set to

"*" & globalvariable & "*".

The query criteria would be set to

Like Function()

This would allow you to enter a phrase and find it anywhere in a string.

 

[iddqd]

Well, I was thinking I could use a parameter query to do this. I thought someone did this already and has the SQL code. But I guess not