Counts the number of records in a table.
Function RecCount(ByVal hTable As Long) As Long
The handle to the table.
RecCount returns the number of records that meet the conditions specified in any filters assigned to the table handle. If no filters are set, RecCount returns the total number of records in the table.
This operation is very quick if the table is not filtered. Filters make movement through the table slower.