Microsoft Office Tutorials and References
In Depth Information
The Recordset Object
When a database request returns rows to your program, they are made available through the
Key Properties and Methods of the Recordset Object
Table 23-8 lists some of the key properties and methods associated with the Recordset object.
Table 23-8. Key Properties and Methods of the Recordset Object
Property: points to an open Connection object that will be used to
execute the command or contains a connection string that will be
used to connect to the database.
Method: adds a new row to the end of the Recordset .
Property: returns True when the current record pointer is before the
first record in the recordset.
Method: restores the current row in the Recordset to its original
Method: closes an open Recordset object and releases all
Method: deletes the current record.
Property: describes the edit status of the current record. Can be
adEditNone (current record is unchanged), adEditInProgress
(current record has been changed, but not saved), adEditAdd (the
AddNew method created a new, empty record, which hasn’t been
saved yet), or adEditDelete (the current record is deleted).
Property: returns True when the current record pointer is past the
last row in the recordset.
Property: returns a Fields collection containing the set of fields
associated with the current record.
Property: can be a string containing an expression similar to an
SQL Where clause.
Method: moves the current record pointer forward (positive value)
or backward (negative value) the specified number of rows.
Method: moves the current record pointer to the first row in
the Recordset .
Method: moves the current record pointer to the last row in
the Recordset .