Moving a recordset into an array

  • Thread starter Thread starter Dennis Snelgrove
  • Start date 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...
 
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:@MSITStore:C:\Program%20Files\Common%20Files\Microsoft%20Shared\OFFICE11\1033\dao360.chm::/damthGetRows.htm
 
Back
Top