looping through recordset using maybe index for recrods?

G

Guest

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
 
G

Guest

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 - Problem updating records 5
Loop through recordset with a twist 2
looping through recordset 5
Jump to specific record in recordset 1
Final .MoveNext in recordset is very slow 10
Exporting Access table using a button click in exce 4
Moving a recordset into an array 1
Using For Each...In...Next to loop through recordset 5

Top