Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski 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

Status
Not open for further replies.
stevozip

stevozip

Computer
Joined
Jan 25, 2002
Messages
1
Location
US
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?
 
Status
Not open for further replies.

Similar threads

Bheem369
  • Locked
  • Question Question
MACRO TO CREATE CLOSE SURFACE FROM STYLING SURFACE IN CATIA
Replies
2
Views
2K
Bheem369
Bheem369
Windchill Creo
  • Locked
  • Question Question
Need to check the State of existing files in PDM(Winchill) +Creo
Replies
0
Views
343
Windchill Creo
Windchill Creo
JoelTXCive
  • Locked
  • Question Question
Sending an Array into an Excel VBA function and Also Getting an Array Out
Replies
6
Views
1K
IDS
IDS
Costalrays
  • Locked
  • Question Question
Newbie here trying to understand how best to solve BOM
Replies
2
Views
1K
SkipVought
SkipVought
rotw
  • Locked
  • Question Question
Sending Visual Basic Output Window (Program Output) to a Form (Text Box) or File
Replies
11
Views
2K
rotw
rotw

Part and Inventory Search

Sponsor

Back
Top