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?
without running a loop with a counter in it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Allen Browne
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.)
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.)
G
Guest
Do you have some examples of AbsolutePosition? I couldn't find it in the help
files.
files.
A
Allen Browne
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
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