Access Database Design and Programming, Second Edition

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