Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Congratulations GregLocock on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using an ADO control to search an Access database

Thread starter stevozip
Start date Jan 26, 2002

Status: Not open for further replies.

Jan 26, 2002

stevozip

Computer

I am writing a program which utilizes the ADO control. I have linked a database file, lotus.mdb, to the control and need to be able to search the database. Now, I have a VB book I used for school that has code for searching a database using the Data control in VB. Here's the code I'm having trouble converting to ADO:

datfind.recordset.findfirst

and

datfind.recordset.nomatch

and

datfind.recordset.findnext

Visual Basic does not like FindFirst, NoMatch, and FindNext with the ADO control. What are the commands i would use for this instead?