Class Recordsets (DAO VBA)

A Recordsets collection contains all open Recordset objects in a Connection or Database object. To use a Recordsets class variable it first needs to be instantiated, for example

Dim rsts as Recordsets
Set rsts = Workspaces(1).Databases(1).Recordsets

Count

Returns the number of objects in the specified collection.

Because members of a collection begin with 0, you should always code loops starting with the 0 member and ending with the value of the Count property minus 1. If you want to loop through the members of a collection without checking the Count property, you can use a For Each...Next command. The Count property setting is never Null. If its value is 0, there are no objects in the collection.

Dim rsts As DAO.Recordsets: Set rsts = 
rsts.Count

Item

Item (Item)

Refresh

Not supported for this object.

You can't use the Refresh method with collections that aren't persistent, such as Connections, Databases, Recordsets, Workspaces, or the QueryDefs collection of a Connection object.

Dim rsts As DAO.Recordsets: Set rsts = 
rsts.Refresh