Please help me! SEARCH Database

[UDM_Seneca]

I have a project I am doing for a school library. Our group of students has to put an entire Library CD collection of images onto the hard drive of a computer. Done.

The hard part:

Create an exe program in VB 5.0 that will serve as an interface to search these images and their corresponding Access Database (Also Done...).

HOW do I make a working keyword search? I have searched your awsome site and can't find an applicable script. Is this even possible? For a user to enter 'golf', hit search, and then all the 'description' fields in Access are scanned for the word 'golf'?

You guys are pure VB, please tell me you can help.

thanks in advance
VB_cHiCk

[kovan]

you need to dig DAO or ADO(use this one)
and the SQL statemetn you will use will be something like

SQL = "SELECT * FROM myTable WHERE Description = '" & txtuserInputbox.text & "'"

[Ecniv]

You will want wildcard searchs probably.



Something like :

DAO :
Select table.* From table where field like '*" & txtInput & "*';"

ADO :
Select table.* From table where field like '%" & txtInput & "%';"


Regards

Vince