Solved

ado data control

Posted on 2003-11-04
2
142 Views
Last Modified: 2010-05-03
i would like to keep track of what record number i am viewing when i scroll through my ADO data control. So, how do i display the record number in my ADO dc's Caption. I have the adodc connected to an Access table.
0
Comment
Question by:joyful88
2 Comments
 
LVL 3

Expert Comment

by:NBrownoh
ID: 9683279
this should be what you need:

TheCurrentRecordNumber& = Adodc1.Recordset.AbsolutePosition
0
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 50 total points
ID: 9685345
Put your code in the MoveComplete event:

Private Sub Adodc1_MoveComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)

    Adodc1.Caption = Adodc1.Recordset.AbsolutePosition

End Sub
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBA error replacing data 6 39
Windows 10 start screen issues 9 54
Computer crashes, following error message in event manager 5 194
clicking a shape in a frame array vb6 3 45
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question