Please enable JavaScript.
Coggle requires JavaScript to display documents.
ADO recordset (methods (add new, movefirst, movenext, MovePrevious, …
ADO recordset
methods
-
-
-
-
-
.Move numrecords, start: Specifies the number of records to move through and the starting point
-
-
-
-
properties
-
.AbsolutePosition: Returns a number indicating which row the cursor is in (1 is the first record, 2 is the second record, and so forth.)
-
-
-
-
Field names in recordsets
In a recordset, each record is a collection of fields.
myRecordSet.Fields(0) refers to the first field in the record, myRecordset.Fields(1) refers to the second field, and so forth. You can also refer to fields by their names. The syntax is myRecordSet.Fields(“fieldname”) where fieldname is the name of the field as defined in the table. You must type the fieldname exactly as it appears in the table’s Design view (including spaces).
The .RecordCount and .AbsolutePosition properties only return correct values when you’re using a static cursor type, which is another reason why we use adOpenStatic as the cursor type in our examples. When using a dynamic cursor, .RecordCount and .AbsolutePosition always return -1. because the number and position of the records in the recordset may change.