Search form (I know there's a thread) but more specific 1

[BotCow]

Okay this is a more specific question on a search form. I have it working just fine so that it will search a field that usually contains more than one word (for instance it is a memo field, or a note-to-self field, or any field generally longer than name, last name, or DOB etc). However, it will only search consecutive words or just a single word in the field eg, if I have a memo field that says, "Gatorade rocks in the summer heat," and I search for "Gatorade", it'll find it. If I search for "rocks in the", it will also find it. But if I search for "Gatorade summer", it won't find it. I want the memo field I have to function like a bunch of keywords, any combination of words or strings even closely matching with it will work. Any suggestions?

 

[LonnieJohnson]

I would use some type of parsing routine. Maybe start with the Mid function. With this you can analyze your search string. Each time you come to a space, break that up with an OR operator.

Thus, you would take "Gatorade summer" and split it up into a new criteria string like so...

strCriteria = "MyField Like '*Gatorade*' OR MyField Like '*summer*'"

This is just the concept and not the actual code.

Hope it gets you going.



ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[BotCow]

Yea, that does help a lot, now if I wasn't so darn VBA deprived I would code that in a heartbeat I'm sure. Hrmm, shouldn't be too hard.

 

[LonnieJohnson]

If you haven't gotten it by Monday morning, email me at the address below with more details and I can probably throw something together.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!