Recordset

Methods

Name	Returns	Description
AddNew		Creates a new record in the Recordset .
Cancel		Cancels execution of an asynchronous Execute, OpenRecordset , or OpenConnection .
CancelUpdate		Cancels any pending Update statements.
Clone	Recordset	Creates a duplicate Recordset .
Close		Closes an open DAO object.
CopyQueryDef	QueryDef	Returns a copy of the QueryDef that created the Recordset .
Delete		Deletes a record from a Recordset .
Edit		Prepares a row of a Recordset for editing.
FillCache		Fills the cache for an ODBC-derived Recordset .
FindFirst		Locates the first record that satisfies the criteria.
FindLast		Locates the last record that satisfies the criteria.
FindNext		Locates the next record that satisfies the criteria.
FindPrevious		Locates the previous record that satisfies the criteria.
GetRows	Variant	Retrieves multiple records of a Recordset into an array.
Move		Moves the position of the current record in a Recordset .
MoveFirst		Moves to the first record in the Recordset .
MoveLast		Moves to the last record in the Recordset .
MoveNext		Moves to the next record in the Recordset .
MovePrevious		Moves to the previous record in the Recordset .
NextRecordset	Boolean	Fetches next recordset in a multi-query Recordset
OpenRecordset	Recordset	Creates a new Recordset object.
Requery		Re-executes the query the Recordset is based on.
Seek		Locates a record in a table-type Recordset .
Update		Saves changes made with the Edit or AddNew methods.

Properties

Name	Returns	Description
AbsolutePosition	Long	Sets or returns the relative record number of the current record.
BatchCollisionCount		Indicates how many rows had collisions in the last batch update. Read-only.
BatchCollisions	Variant	Indicates which rows had collisions in the last batch update. Read-only.
BatchSize	Long	Determines how many updates to include in a batch.
BOF	Boolean	Indicates whether the current record position is before the first record. Read-only.
Bookmark		Uniquely identifies a particular record in a Recordset .
Bookmarkable	Boolean	Indicates whether a Recordset supports bookmark. Read-only.
CacheSize	Long	Sets or returns the number of records to be locally cached from an ODBC data source.
CacheStart		Sets or returns the bookmark of the first record to be cached from an ODBC data source.
Connection	Connection	Indicates which Connection owns the Recordset .
DateCreated	Variant	Returns the date and time when the underlying base table was created. Read-only.
EditMode	Integer	Returns the state of editing for the current record. Read-only.
EOF	Boolean	Indicates whether the current record position is after the last record. Read-only.
Fields	Fields	Collection of Field objects in a Recordset object. Read-only.
Filter	String	Sets or returns a value indicating a filter to apply to a Recordset .
Index	String	Sets or returns the name of the current Index object (table-type Recordset only).
LastModified		Returns a bookmark indicating the most recently added or changed record. Read-only.
LastUpdated	Variant	Returns the date and time of the most recent change to an object. Read-only.
LockEdits	Boolean	Returns the type of locking in effect during editing.
Name	String	Returns the name of this object. Read-only.
NoMatch	Boolean	Indicates whether a record was found with the Seek or Find method. Read-only.
PercentPosition	Single	Sets or returns the approximate location of the current record.
Properties	Properties	Collection of Property objects. Read-only.
RecordCount	Long	Returns the number of records accessed in a Recordset . Read-only.
RecordStatus	Integer	Indicating the batch-update status of the current record. Read-only.
Restartable	Boolean	Indicates whether a Recordset object supports the Requery method. Read-only.
Sort	String	Sets or returns the sort order for records in a Recordset .
StillExecuting	Boolean	Indicates whether an asynchronous method call is still executing. Read-only.
Transactions	Boolean	Indicates whether the Recordset object supports transaction. Read-only.
Type	Integer	Returns the data type of an object. Read-only.
Updatable	Boolean	Returns whether records in the Recordset can be update. Read-only.
UpdateOptions	Long	Determines how a batch update query will be constructed .
ValidationRule	String	Sets or returns a value indicating whether a field contains valid data. Read-only.
ValidationText	String	Sets or returns a value indicating a message if an entered value is invalid. Read-only.