Count records in a recordset (VBA)
Posted on 2001-09-03
I have a recordset called rsMerge in my code and I want to get the number of records in that recordset so that I can do a test.
If the number of records is 1 the program flow will be different, and if more than 1 then the flow will be different.
I have tried using .MoveLast and .RecordCount but this is extremely slow, and I have 300,000 records to process.
I need something much faster! Please can anyone help?