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.