Moving a recordset into an array

  • Thread starter Dennis Snelgrove
  • Start date
D

Dennis Snelgrove

Excepting through a For/Next loop, is there a way to take a DAO
recordset and move it directly into an array? I need to compare the
same field from different records and being able to do a "If
a(x)=a(x-3) Then" would be much easier than having to keep bouncing
around with ".MoveNext" and ".MoveBack".

Alternatively, is there a recordset way of referencing a specific
record other than the current one?

Thanks for any insights...
 
B

Brendan Reynolds

See 'GetRows Method' in the help files.

If you're using Office 2003 and installed into the default location, you can
open the help topic directly using the following URL via the Windows Start,
Run command ...

mk:mad:MSITStore:C:\Program%20Files\Common%20Files\Microsoft%20Shared\OFFICE11\1033\dao360.chm::/damthGetRows.htm
 

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

Loop through recordset with a twist 2
Copy ADO Recordset 2
Recordset within a recordset? 5
looping through recordset using maybe index for recrods? 2
Final .MoveNext in recordset is very slow 10
DCount on a recordset? 5
Dynamically referencing a recordset? 9
checking .bof and .eof for empty recordset? 4

Top