Beginning Access 1002002 Vba [Electronic resources]

Robert Smith; Dave Sussman Et al

نسخه متنی -صفحه : 256/ 219
نمايش فراداده

Recordset

Methods

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

QueryDef

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.

Properties

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.

Connection

Connection

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.

Fields

Fields

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 .

Index

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.

Properties

Properties

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.