Need help with a search funktion

Need help with a search funktion

Post by Toma » Sat, 26 May 2001 03:52:30



I've just starting to learn some baisc vb6 programming, and I've made a
program that keeps all my videos in a access database, and to that I've made
a program that I can add, delete and change records. I can also go to a
speciffic "startingletter" (the first letter of the name), but now I want to
make so that I can search for s specific video, how do I do this?
 
 
 

Need help with a search funktion

Post by Jean-Francois Breto » Sat, 26 May 2001 19:53:51


It depends of the situation :
If you use a recordset, use the "Filter" property of the recordset.
If you use SQL query, use the LIKE statement in the WHERE clause.



Quote:> I've just starting to learn some baisc vb6 programming, and I've made a
> program that keeps all my videos in a access database, and to that I've
made
> a program that I can add, delete and change records. I can also go to a
> speciffic "startingletter" (the first letter of the name), but now I want
to
> make so that I can search for s specific video, how do I do this?