ADO: ActiveX Data Objects

Name

Recordset.Find Method — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

                     recordset.Find (Criteria, SkipRows, SearchDirections, Start)

The Find method moves the record pointer to a row within the current recordset that matches the single-column search criteria specified.

Arguments

Criteria (String)

Specifies a single-column search criteria in the form of 'Column Operator Value'. The Column portion is a name of a column in the Recordset object. The Operator can be >, <, =, >=, <=, <>, or LIKE. The value can be written as a string, floating point number, or date. Strings are deliminated with single strings or number signs (#) and dates are deliminated with number signs (#). When using the LIKE operator, asterisks (*) can be used at the end or both the beginning and the end of the value ('*jr*', 'jr*'). If the asterisks is used at the beginning only, an error will occur.

SkipRows (Long)

Optional. Indicates how many rows to skip before searching the recordset for a match to the Criteria argument. The default is 0, meaning the search will begin on the current row.

SearchDirection (SearchDirectionEnum)

Optional. Indicates whether to search forward or backward through the recordset. If a match is not found and a forward search is being done, the record pointer will point to the EOF marker. If a backward search is done and a match is not found, the record pointer will point to the BOF marker. By default, a forward search is done.

Start (Variant)

Optional. Specifies a starting position for the search ...