By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,961 Members | 1,333 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,961 IT Pros & Developers. It's quick & easy.

How do I use an ADO connection to look up 1 field in a database?

P: 27
I'm using an ado connection to connect to an access database using VB6.0.

The database structure has a table (Table1), with a unique field1 (ID), and another field2 (Name).

How do I use an ado connection to lookup a Name when given an ID? Within Access, I would use a dlookup command and dump the data into a variable...but I'm not sure how to do that using ADO.

Thanks!
Apr 11 '07 #1
Share this Question
Share on Google+
2 Replies


Denburt
Expert 100+
P: 1,356
Sorry my previous post lost some info this PC is acting screwy...

Reordset information can be found here:
http://msdn2.microsoft.com/en-us/library/ms681510.aspx


Some more interesting samples/methods:
http://msdn2.microsoft.com/en-us/library/ms675104.aspx
Apr 11 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.