ADO RecordSet Process

Search/process the fetched data

Access

GetRows

Used to copy either all or a specified number of records into a two-dimensional array.

GetString

Returns the specified Recordset as a string.

Save

Saves the Recordset to a file or Stream object.

Delete

Deletes the current record, a group of records, or all records.

Search

Find

Searches for a row in a Recordset that matches the given criteria.

Seek

Uses the index of a Recordset to locate a specified row.

Move

MoveFirst method

Moves the position of the current record pointer to the first record.

MoveLast method

Moves the position of the current record pointer to the last record.

MoveNext method

Moves the position of the current record pointer forward to the next record.

If you are at the last record, calling this method will put you at EOF and the EOF property will be set to True. If you are at EOF and call this method, an error will be generated.

MovePrevious method

Moves the position of the current record pointer back to the previous record.

If you are at the first record, calling this method will put you at BOF and the BOF property will be set to True. If you are at BOF and call this method, an error will be generated.

Sort

The Sort property sets or returns a string value that provides the names of the fields in the Recordset that you wish sorted. Each name must be separated by a delimiter comma and the entire string must be enclosed within a pair of double quotes. If the field name contains blank spaces, you need to enclose it within a pair of square brackets.

You also have the option of specifying that the sort be in ascending or descending order for each individual field. You can declare the sort order by placing a blank space followed by either the keyword ASC, for an ascending sort, or DESC, for a descending sort, directly after the field name, but before the delimiter comma. The default is to sort in ascending order.

The CursorLocation property will need to be set to adUseClient.