Access VBA DAO

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

1
2
3
4
src.MoveLast
src.MoveFirst
 
src.RecordCount

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