Recordset members (DAO)

Applies to: Access 2013, Office 2013

A Recordset object represents the records in a base table or the records that result from running a query.

Methods

Name	Description
AddNew	Creates a new record for an updatable Recordset object.
Cancel	NOTE: ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine. Cancels execution of a pending asynchronous method call (ODBCDirect workspaces only).
CancelUpdate	Cancels any pending updates for a Recordset object.
Clone	Creates a duplicate Recordset object that refers to the original Recordset object.
Close	Closes an open Recordset.
CopyQueryDef	Returns a QueryDef object that is a copy of the QueryDef used to create the Recordset object represented by the recordset placeholder (Microsoft Access workspaces only). .
Delete	Not supported for this object.
Edit	Copies the current record from an updatable Recordset object to the copy buffer for subsequent editing.
FillCache	Fills all or a part of a local cache for a Recordset object that contains data from a Microsoft Access database engine-connected ODBC data source (Microsoft Access database engine-connected ODBC databases only).
FindFirst	Locates the first record in a dynaset- or snapshot-type Recordset object that satisfies the specified criteria and makes that record the current record (Microsoft Access workspaces only).
FindLast	Locates the last record in a dynaset- or snapshot-type Recordset object that satisfies the specified criteria and makes that record the current record (Microsoft Access workspaces only).
FindNext	Locates the next record in a dynaset- or snapshot-type Recordset object that satisfies the specified criteria and makes that record the current record (Microsoft Access workspaces only). .
FindPrevious	Locates the previous record in a dynaset- or snapshot-type Recordset object that satisfies the specified criteria and makes that record the current record (Microsoft Access workspaces only). .
GetRows	Retrieves multiple rows from a Recordset object.
Move	Moves the position of the current record in a Recordset object.
MoveFirst	Moves to the first record in a specified Recordset object and make that record the current record.
MoveLast	Moves to the last record in a specified Recordset object and make that record the current record.
MoveNext	Moves to the next record in a specified Recordset object and make that record the current record.
MovePrevious	Moves to the previous record in a specified Recordset object and make that record the current record.
NextRecordset	NOTE: ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine. Gets the next set of records, if any, returned by a multi-part select query in an OpenRecordset call, and returns a Boolean value indicating whether one or more additional records are pending (ODBCDirect workspaces only).
OpenRecordset	Creates a new Recordset object and appends it to the Recordsets collection.
Requery	Updates the data in a Recordset object by re-executing the query on which the object is based.
Seek	Locates the record in an indexed table-type Recordset object that satisfies the specified criteria for the current index and makes that record the current record (Microsoft Access workspaces only).
Update	NOTE: ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine. Saves the contents of the copy buffer to an updatable Recordset object.

Properties

Name	Description
AbsolutePosition	Sets or returns the relative record number of a Recordset object's current record.
BatchCollisionCount	NOTE: ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine. Returns the number of records that did not complete the last batch update (ODBCDirect workspaces only).
BatchCollisions	NOTE: ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine. Returns an array of bookmarks indicating the rows that generated collisions in the last batch update operation (ODBCDirect workspaces only).
BatchSize	NOTE: ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine. Sets or returns the number of statements sent back to the server in each batch (ODBCDirect workspaces only).
BOF	Returns a value that indicates whether the current record position is before the first record in a Recordset object. Read-only Boolean.
Bookmark	Sets or returns a bookmark that uniquely identifies the current record in a Recordset object.
Bookmarkable	Returns a value that indicates whether a Recordset object supports bookmarks, which you can set by using the Bookmark property.
CacheSize	Sets or returns the number of records retrieved from an ODBC data source that will be cached locally. Read/write Long.
CacheStart	Sets or returns a value that specifies the bookmark of the first record in a dynaset-type Recordset object containing data to be locally cached from an ODBC data source (Microsoft Access workspaces only).
Connection	Returns the Connection object that corresponds to the database.
DateCreated	Returns the date and time a base table was created (Microsoft Access workspaces only). Read-only Variant.
EditMode	Returns a value that indicates the state of editing for the current record.
EOF	Returns a value that indicates whether the current record position is after the last record in a Recordset object. Read-only Boolean.
Fields	Returns a Fields collection that represents all stored Field objects for the specified object. Read-only.
Filter	Sets or returns a value that determines the records included in a subsequently opened Recordset object (Microsoft Access workspaces only). Read/write String.
Index	Sets or returns a value that indicates the name of the current Index object in a table-type Recordset object (Microsoft Access workspaces only).
LastModified	Returns a ookmark indicating the most recently added or changed record.
LastUpdated	Returns the date and time of the most recent change made to a base table. Read-only Variant.
LockEdits	Sets or returns a value indicating the type of locking that is in effect while editing.
Name	Returns the name of the specified object. Read-only String.
NoMatch	Indicates whether a particular record was found by using the Seek method or one of the Find methods (Microsoft Access workspaces only).
PercentPosition	Sets or returns a value indicating the approximate location of the current record in the Recordset object based on a percentage of the records in the Recordset.
Properties	Returns the Properties collection of the specified object. Read-only.
RecordCount	Returns the number of records accessed in a Recordset object, or the total number of records in a table-type Recordset object. or TableDef object. Read-only Long.
RecordStatus	NOTE: ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine. Returns a value indicating the update status of the current record if it is part of a batch update (ODBCDirect workspaces only). Read-only RecordStatusEnum.
Restartable	Returns a value that indicates whether a Recordset object supports the Requery method, which re-executes the query on which the Recordset object is based.
Sort	Sets or returns the sort order for records in a Recordset object (Microsoft Access workspaces only).
StillExecuting	NOTE: ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine. Indicates whether or not an asynchronous operation (that is, a method called with the dbRunAsync option) has finished executing (ODBCDirect workspaces only).
Transactions	Returns a value that indicates whether an object supports transactions. Read-only Boolean.
Type	The description for this member will appear in the final release of Office 14.
Updatable	Returns a value that indicates whether you can change a DAO object. Read-only Boolean.
UpdateOptions	NOTE: ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine. Sets or returns a value that indicates how the WHERE clause is constructed for each record during a batch update, and whether the batch update should use an UPDATE statement or a DELETE followed by an INSERT (ODBCDirect workspaces only). Read/write UpdateCriteriaEnum.
ValidationRule	Sets or returns a value that validates the data in a field as it's changed or added to a table (Microsoft Access workspaces only).Read/write String.
ValidationText	Sets or returns a value that specifies the text of the message that your application displays if the value of a Field object doesn't satisfy the validation rule specified by the ValidationRule property setting (Microsoft Access workspaces only). Read-only String.