Search Function

[MisterHi]

Hi

i have written a search function in vb , to search something out of a database
But now i have to write a function that searches a part of the string,
so you have to enter only a couple of letters and he show you the name instead of typing the whole name.

I don't know how to start on this one ?

Somebody could help me?

Thanks in advance !

 

[MattP]

Not exactly sure which situation matches your request from your description. Either way it's easy to implement.

How Do I: Create a Search Form?

How Do I: Use Auto-Complete?

 

[MisterHi]

Hi thank you vey much,

But i have to make a final project for school and i can't do it automatic
So i have to type all code manually (code for connect to Database, .....) !

The video is what i want , but i need the code or somehting else to start.

 

[jmcilhinney]

Instead of using "Column = Value" in your SQL code you use "Column LIKE Value", where Value contains one or more wildcards. For instance, 'C%' will match all values that start with 'C'.