moving through records

ok what settings need to take place to just be able to move to next records using ado on the client side.It seems like the only way I can do it is to delete the current record and move to the next record but this I do not want to do I want to be able to move to the next record without deleting.
Who is Participating?
jomacincConnect With a Mentor Commented:
How are you opening the recordset then?
Sounds like a curser problem, can you post you code for just that?
Dim oADO As ADODB.Recordset

' << Open Recordset Here >>

Do While Not oADO.EOF
  ' << do whatever you need with this record >>
  Call oADO.MoveNext
The point there is the "MoveNext" method.
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

thenoneAuthor Commented:
I do that and it doesn't movenext exactly what you have written.
thenoneAuthor Commented:
no its something else that is going on and I figured it out.Since I answered my own question can you answer another question.If I am showing all records in a set in maybe a label and I am not deleting them to count down.Ho can I show how many records that I have left to move thru.
Use the "AbsolutePosition" property

[Number of Records Left] = oADO.RecordCount - oADO.AbsolutePosition
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.