Moving a recordset into an array

  • Thread starter Dennis Snelgrove
  • Start date


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...



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 ...


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