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 |
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. |
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. |
|
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. |
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 . |
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. |
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. |