looping through recordset using maybe index for recrods?

C

chun

Hi all,

Thank you in advance for your help.

I know I can loop through an ADODB recordset by movenext. Is there a way to
loop through it using some index for the recrods? I am looping through
multiple tables at the same pace. For example, i want to be able to pick the
fourth records from 5 recordset. Thanks a lot.

chun
 
C

chun

I just use getrows() to convert the recordset to an array. Is this the best
approach? thanks.
 
G

George Nicholson

Look at the help entry for the AbsolutePosition property and see if that
sounds like what you want, but read the warnings to make sure they don't
apply to your situation:
"You should not use the AbsolutePosition property as a surrogate record
number...."

HTH,
 

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

looping through recordset 8
Loop through recordset with a twist 1
Looping through a Large recordset. 2
record count of table while looping through all tables 2
Jump to specific record in recordset 1
Exporting Access table using a button click in exce 4
Recordset is not filtering Report- version 2 6
Looping through a recordset and sending a report as an email 8

Top