>I have a recordset that has a variable number or integers that I would like to add to an array. I then want to loop through this array during other subs and functions. Does anyone have some advice to get started?
Both DAO and ADO recordsets have a function called GetRows() that returns your data in a multidimensional array. You might need to do some transposing because the result gives you columns and rows that are the opposite of a recordset. HTH
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement