Find Records in Access DB

[ppedersen1]

H-E-L-L-O. I am creating a program which pulls data out of an Access database. I want to use automation to search the records using the search function in Access. I don't know the correct function to use and how to say it. But I know how to set the preferences, there are just too many "find" options in the Object Browser. Any help would be appreciated.

 

[TheTuna]

Are you wanting to do this in VB 5/6 with an external Access database?

If so, it's not so hard... Assuming this is a newer version of Access, use ADO. The fastest way would be to add an ADO data control to your form, connect it to the database using the ConnectionString property. The dialog will allow you to choose an ODBC source or build a connection string choose the appropriate Jet Driver (it will list many drivers, most likely you'll use Jet 4)... next you'll be given a dialog to browse for the access database.

you'll be able to build your simple sql string to query the database. MS provides excellent help for this, hit F1 and search for ADO. Tuna - It's fat free until you add the Mayo!