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

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

Subscribe Post Reply

1186

Denburt

1,356

Expert 1GB

http://www.thescripts.com/forum/thread629543.html

Apr 11 '07 #2

Denburt

1,356

Expert 1GB

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

by: jj | last post by:

Is it possible to call a remote php script from within Access? I'm thinking something like: DoCMD... http://www.domain.com/scripts/dataquery.php DoCmd.OpenQuery "update_data", acNormal, acEdit...

Microsoft Access / VBA

Database Connection questions.

by: pradeep_TP | last post by:

Hi all, I have a few questions that I have been wanting to ask for long. These are all related to ADO.net and specifically to conenction to database. 1) If I have opened a connection to a...

C# / C Sharp

DSN-less connection for Informix database

by: Bill Nguyen | last post by:

I have this connection string using ODBC DSN Dim FactorJaco As String = "dsn=jaco;catalog=factor;uid=user;pwd=passord" This requires an ODBC DSN (jaco) at every client PC. I need to use DSN-less...

Visual Basic .NET

help with connection string

by: Jennifer.Berube | last post by:

well I'm not sure how to go about making my SQL connection string... The code below is what I need to replace with my SQL connection...I just don't know if that code is for DSN or access... I...

ASP / Active Server Pages

ADODB.Connection & Recordset

by: bowlerdave | last post by:

I have a form that shows policy information for an insurance brokerage. When I enter the effective and expiration date of a policy, it calculates and updates a field called DaysInsured. If a...

Microsoft Access / VBA

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

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

Similar topics