ADODB.RecordSet

An ADODB.RecordSet object represents a set of records from a table/view or an SQL select statement.

Each record of the recordset consists of multiple fields.

Iterating over a recordSet

The method moveNext() advances to the next record in a record set. The property EOF (end of file?) indicates if the end is reached.

Thus, in VBA, it is possible to iterate over a record set like so:

set rs = new adodb.recordset
rs.open "select …", conn

do while not rs.eof
   …
   rs.moveNext
loop

`absolutePage`
`absolutePosition`
`activeCommand`
`activeConnection`
`addNew()`
`BOF`, `EOF`, `EOS`
`bookmark`
`cacheSize`
`cancel()`
`cancelBatch()`
`cancelUpdate()`
`clone()`
`close()`	Frees system resources associated with the `recordset` object.
`compareBookmarks()`
`cursorLocation`
`cursorType`
`dataMember`
`dataSource`
`delete()`
`editMode`
`endOfRecordset()`	Event
`fetchComplete()`	Event
`fetchProgress()`	Event
`fields`	A collection of `field` objects.
`filter`
`find()`
`getRows()`
`getString()`
`index`
`lockType`
`marshalOptions`
`maxRecords`
`move()`
`moveFirst()`
`moveLast()`
`moveNext()`
`movePrevious()`
`nextRecordset()`
`open()`
`pageCount`
`pageSize`
`properties Collection`
`recordCount`
`requery()`
`resync()`
`save()`
`seek()`
`sort`
`source`
`state`
`status`
`stayInSync`
`supports()`
`update()`
`updateBatch()`
`willChangeField()`, `fieldChangeComplete()`	Events
`willChangeRecord()`, `recordChangeComplete()`	Events
`willChangeRecordset()`, `recordsetChangeComplete()`	Events
`willMove()`, `moveComplete()`	Events