Hi everybody,
I'm trying to build a search form in VBA. What it should basicially do is retreive a string from an ImputBox, and return all the records where it apperas as a word, or as a part of a word.
For example, if the input is do,and one feild of the 2nd record has the word undo,and a different feild in the 10th record has the word done, I'd have both those records .
So how do I do it in VBA, or maybe SQL or a qry would be better? So far I tried all three methods and nothing worked.
Thanks a lot!
I'm trying to build a search form in VBA. What it should basicially do is retreive a string from an ImputBox, and return all the records where it apperas as a word, or as a part of a word.
For example, if the input is do,and one feild of the 2nd record has the word undo,and a different feild in the 10th record has the word done, I'd have both those records .
So how do I do it in VBA, or maybe SQL or a qry would be better? So far I tried all three methods and nothing worked.
Thanks a lot!