• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part VII: Appendixes > Recordset Object

A.15. Recordset Object

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


A.15.2. 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 to the current position or to a bookmark
MoveFirst   Sub 3.0/3.5 Moves to the first record in the Recordset
MoveLast   Sub 3.0 Moves to the last record in the Recordset
MoveLast [Options As Long] Sub 3.5 Moves to the last record in the Recordset
MoveNext   Sub 3.0/3.5 Moves to the next record in the Recordset
MovePrevious   Sub 3.0/3.5 Moves to the previous record in the Recordset
NextRecordset   Boolean 3.5 Retrieves the next recordset in a multiquery Recordset
OpenRecordset [Type], [Options] Recordset 3.0/3.5 Creates a new Recordset object
Requery [NewQueryDef] Sub 3.0/3.5 Re-executes the query on which the Recordset is based
Seek Comparison As String, Key1... Sub 3.0/3.5 Locates a record in a table-type Recordset
Update   Sub 3.0/3.5 Saves changes initiated by the Edit or AddNew methods



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint