Snapshot Object (Professional Edition Only)

See AlsovbobjSnapshotSee              PropertiesvbobjSnapshotProp           MethodsvbobjSnapshotMth


A type of recordset22S7WAF that is the result of a query and that does not have updatable records.  Like a Table, a Snapshot has records (rows) and fields (columns).  A Snapshot is a static picture of a set of records you can use to find data or generate reports.  A Snapshot can contain fields from one or more tables in a database.


In the Professional Edition, you can declare an object variableZ3R9Q5 as a Snapshot type.  To create a Snapshot for an object variable, use the CreateSnapshot  method on a Database, Dynaset, or another Snapshot.  You can have more than one Snapshot object variable containing the same set of records.

Like all recordsets, when you create a Snapshot, the first record is the current record1BNJB8X, and you can use any of the Move methods, such as MoveNext, to move the current record to a different record.  You can also use the Find methods, such as FindFirst, to move to a specific record.  To cycle through all records, you can use the BOF and EOF properties to check for the beginning or end of the Snapshot.