PS. I have just worked up an example QBF search form, using the Northwind
sample database, that allows one to search for street names. I'm willing to
share this with you, in addition to a more involved QBF search for the
original sample I mentioned.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
It sounds like a classic Query-by-Form (QBF) search form, where you build the
WHERE clause of a SQL (structured query language) statement on the fly would
serve you nicely. You need to be comfortable working with VBA code in order
to implement such an idea.
If you send me a private e-mail message, with a valid reply-to address, I
will send you a zipped sample database that includes such a QBF. My e-mail
address is available at the bottom of the contributors page indicated in my
signature. Please do not post your real e-mail address (or mine) to a reply
to the newsgroup. Doing so will only invite the unwanted attention of
spammers.
Tom
http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
:
I have a table of steet names I would like to filter using a table of words.
My goal is that the resulting data set will only include those street names
that have a portion of any one word in the word table in their name.
What would you suggest I do to accomplish this?
