Recordset Object

ActiveConnection

Returns the Connection object that was used to open the Recordset.

BOF

Indicates that the cursor is currently positioned before the first record in the Recordset.

CommandType

Sets or returns the type of command specified in the Source object.

CursorLocation

Returns the location of the cursor service for a Recordset.

CursorType

Returns the type of cursor to be used for a Recordset.

EditMode

Returns the editing state of the current record in the Recordset.

EOF

Indicates that the cursor is currently positioned after the last record in the Recordset.

Fields

Returns a collection of Field objects that represent each column in the Recordset.

Filter

Sets or returns a filter for data in the Recordset.

Index

Sets or returns the name of the current index for the Recordset.

LockType

Returns the type of lock placed on records in the Recordset during editing.

Source

Returns the source of the recordset or the name of a source application (for a DDE link).

AddNew

Creates and initializes a new record (for an updatable Recordset object).

CancelUpdate

Cancels any changes made to the current or new record in a Recordset object.

Close

Closes an open recordset object.

Delete

Deletes the current record from a Recordset.

Find

Searches a Recordset for the row that satisfies the specified criteria.

Move

Moves the cursor to the first, last, next, or previous record in a Recordset object.

Seek

Searches the index of a Recordset object to quickly locate the record that matches the specified values, and sets that record as the current record.

Update

Saves any changes to the current record of a Recordset object.