0

I would like to create a textbox (search engine) that can search for items in a database that contains text as that keyed in the textbox.
I am already aware of this code:
bindingsource.filter = "table Like '" & textbox & "%'"
EX:
what I want is that when I entered "a", all items containing "a" will be displayed like
Apple
Banana
Star Apple


_____
Another thing, I would like to create a search engine that can search for FILES from all folders in the whole computer system. I can only search for files from specified folders...Thanks

3
Contributors
3
Replies
5
Views
5 Years
Discussion Span
Last Post by markdean.expres
0

hi. Think you need

fruit LIKE '%a%'

or

fruit LIKe '*a*'


wildcard * or % depends on your database access - Access/sqlserver/oleDB etc. See what works. Substitute "fruit" with the appopriate field name.

0

THANKS A LOT TO CRAPULENCY!!!!!!!!!!! and to the others who gave a speck of their knowledge. It worked!

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.