VBA Access Get Record Count
In this article I will explain how you can get the number of records in a Recordset object.
This article uses the ADODB.Recordset object. In order to use this object you may need to add reference to ADODB object library. For more information on this topic please see the link below:
Note: Previously I’ve explained how you can get the number of records in a Recordset using the Recordset.Recordcount property. Depending on the cursor type chosen when opening the Recordset object this may or may not work. For more information about using this property please see the link below:
The code below will return the number of records in the table:
You can download the file and code used in this article from the link below: