How to do a Record Count?

  • Thread starter Thread starter gcjvanbeek
  • Start date Start date
G

gcjvanbeek

For my application in Access I have to put Values from a Table or Form
into an Array.

I am looking for a method to use a for next loop, something like this
:
For I= 1 to RecordCount (My Table)
MyArray (I)= MyTableValue (Record (I))
Next I

My problem is how to determen the recordcount.
BDW Putting values in an Array is no problem for me.

I need this functionality urgently.

Gerard van Beek
 
Once you've opened the recordset, issue a .MoveLast so that the .RecordCount
property is correct. Don't forget to issue a .MoveFirst before populating
your array.
 
Back
Top