Recordset/offset question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to find out the position/offset of a record within a recordset
without running a loop with a counter in it?
 
Try AbsolutePosition

Careful though: if you are deleting records from this recordset, do some
very thorough testing before you trust this property. (That's not from a bad
experience, it just sounds like a likely trap.)
 
Do you have some examples of AbsolutePosition? I couldn't find it in the help
files.
 
Example:

Function TestAbsPos()
Dim rs As DAO.Recordset
Set rs = DBEngine(0)(0).OpenRecordset("SELECT * FROM tClient;")
Debug.Print rs.AbsolutePosition
rs.MoveNext
Debug.Print rs.AbsolutePosition
rs.Move 100
Debug.Print rs.AbsolutePosition
rs.Close
End Function
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to hide password? 1
Loading recordset at runtime 4
A theoretical question: how best to manage perpetual recordset needs? 25
Error 87 When Creating Large Email Distribution List 1
Go To 3
Endless Loop - Why? 2
How to offset the vertical position of a item selected in the listbox 1
Excel Typed text appears in wrong cell 0

Back
Top