RecCount

Method
Counts the number of records in a table.

Category
Records

 

Syntax
Function RecCount(ByVal hTable As Long) As Long

hTable
The handle to the table.

 

Comments
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.



© 2009 Microsoft Corporation. All rights reserved.