If you have to determine the total count of records in a Recordset, you can use the RecordCount property.

But first you have to move to the last record in the Recordset by using the MoveLast method.

Source Code

src.MoveLast
src.MoveFirst
 
src.RecordCount

Last Updated: 19 September 2017

Hits: 4187

If you have to delete all records from a table using Access VBA DAO, the following method might be helpful.

Last Updated: 06 January 2018

Hits: 3750