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
Recordset object.
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/Method
Description
ActiveConnection
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.
AddNew
Method: adds a new row to the end of the Recordset .
BOF
Property: returns True when the current record pointer is before the
first record in the recordset.
CancelUpdate
Method: restores the current row in the Recordset to its original
values.
Close
Method: closes an open Recordset object and releases all
its resources.
Delete
Method: deletes the current record.
EditMode
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).
EOF
Property: returns True when the current record pointer is past the
last row in the recordset.
Fields
Property: returns a Fields collection containing the set of fields
associated with the current record.
Filter
Property: can be a string containing an expression similar to an
SQL Where clause.
Move(NumRecords)
Method: moves the current record pointer forward (positive value)
or backward (negative value) the specified number of rows.
MoveFirst
Method: moves the current record pointer to the first row in
the Recordset .
MoveLast
Method: moves the current record pointer to the last row in
the Recordset .
continued
Search JabSto ::




Custom Search