Count Method

Returns the number of objects, stored in the collection.

Applies to objects: Workspaces, Connections, Databases, TableDefs, QueryDefs, Relations, Indexes, Recordsets, Fields, Properties.

Syntax

[[Let] RetVal = ] object.Count()

The Count method syntax has these parts:

Part Description
object Required. A reference to an instance of the object.
RetVal Optional. A Long type variable that stores the number of objects in the collection.

Example

A simple example.

 

See Also

Connections Object, Databases Object, Fields Object, Indexes Object, Properties Object, QueryDefs Object, Recordsets Object, Relations Object, TableDefs Object, Workspaces Object.