[AccessD] Fill array from a record

There's a GetRows function, in 2007 at least, and if I recall it was
in 2002 as well:

  Set dbsNorthwind = CurrentDb
   strSQL = "SELECT FirstName, LastName, Title FROM Employees"
   Set rstEmployees = dbsNorthwind.OpenRecordset(SQL, dbOpenSnapshot)

   varRecords = rstEmployees.GetRows(3)
   intNumReturned = UBound(varRecords, 2) + 1
   intNumColumns = UBound(varRecords, 1) + 1

Charlotte Foust

On Thu, Sep 2, 2010 at 3:13 PM, Doug Steele <dbdoug at gmail.com> wrote:
> Isn't there a function in Access to copy the fields of a row directly to an
> array?  I thought there was, but I can't find anything in help
>
> Thanks,
> Doug
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>