Aug 6 2008, 02:23 PM
I want to build an array by cycling through a record set and creating an dynamic array whose
"row" values are based on a field Projno in the rs and whose "column" values
are based on a field Source in the rs....
I don't know how many rows nor columns are involved in a given cycle...
Can anyone help or point me in the right direction..
Aug 6 2008, 02:44 PM
A DAO.Recordset object, as well as an ADO Recordset object, have a method named .GetRows() that allows you to dump the contents of a recordset into a 2 diminsional array ... the Help file in A2003 does fairly well with the methods' description. Please take note that even though the method is named the same for an ADO or DAO recordset, the arguments passed are different ... so be sure to check out the help.
In addition, an ADO Recordset, has a method named .GetString() which will dump the entire recordset into a HUMONGOUS CSV, then you can creatively use Split() to chunk the values into arrays.