Snapshot Object (Professional Edition Only)
See Also Properties MethodsvbobjSnapshotMth
A type of recordset 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. that is the result of a query and that does not have updatable records.
In the Professional Edition, you can declare an object variable 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. as a Snapshot type.
Like all recordsets, when you create a Snapshot, the first record is the current 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., and you can use any of the Move methods, such as MoveNext, to move the current record to a different record.