Recordset Object
Collections
Property |
Type |
Version |
Description |
---|---|---|---|
Connection |
Connection |
3.5 |
Indicates which Connection owns the Recordset |
Fields |
Fields |
3.0/3.5 |
Collection of fields in the Recordset object |
Methods
Method |
Parameters |
Returns |
Version |
Description |
---|---|---|---|---|
AddNew |
Sub |
3.0/3.5 |
Adds a new record to the Recordset | |
Cancel |
Sub |
3.5 |
Cancels execution of an asynchronous Execute, OpenRecordset, or OpenConnection method | |
CancelUpdate |
Sub |
3.0/3.5 |
Cancels any pending AddNew or Update statements | |
Clone |
Recordset |
3.0/3.5 |
Creates a duplicate Recordset | |
Close |
Sub |
3.0/3.5 |
Closes an open Recordset object | |
CopyQueryDef |
QueryDef |
3.0/3.5 |
Returns a copy of the QueryDef that created the Recordset | |
Delete |
Sub |
3.0/3.5 |
Deletes a record from the Recordset | |
Edit |
Sub |
3.0/3.5 |
Prepares a row of the Recordset for editing | |
FillCache |
[Rows], [StartBookmark] |
Sub |
3.0/3.5 |
Fills the cache for an ODBC-derived Recordset |
FindFirst |
Criteria As String |
Sub |
3.0/3.5 |
Locates the first record that satisfies the criteria |
FindLast |
Criteria As String |
Sub |
3.0/3.5 |
Locates the last record that satisfies the criteria |
FindNext |
Criteria As String |
Sub |
3.0/3.5 |
Locates the next record that satisfies the criteria |
FindPrevious |
Criteria As String |
Sub |
3.0/3.5 |
Locates the previous record that satisfies the criteria |
GetRows |
[cRows] |
Variant |
3.0/3.5 |
Writes multiple records into an array |
Move |
Rows As Long, [StartBookmark] |
Sub |
3.0/3.5 |
Repositions the record pointer relative ... |
Get Access Database Design and Programming, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.