Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recordset find 1
- Thread starter studybum
- Start date
-
1
- #2
recordset.Find (criteria, SkipRows, searchDirection, start)
criteria = eg.("nvName = " & strMyName)
[Conditions you might want to state, <SQL>]
skiprows = eg.(1-???)
[How many rows in the recordset you would like to skip]
searchdirection = eg.(adSearchBackWard, adSearchForward)
[The enumerators the function provides.... whether you want
to search from the first record down, or the last record up]
start = (1-??)
[The record you wish to start searching from]
example:
rs.Find "nvName = " & strMyName, 0, adSearchForward, 0
rs.Find "nvName=" & strMyName
[Here, the skiprows and start is by default 0 and the default direction is adSearchForward]
Cheers
criteria = eg.("nvName = " & strMyName)
[Conditions you might want to state, <SQL>]
skiprows = eg.(1-???)
[How many rows in the recordset you would like to skip]
searchdirection = eg.(adSearchBackWard, adSearchForward)
[The enumerators the function provides.... whether you want
to search from the first record down, or the last record up]
start = (1-??)
[The record you wish to start searching from]
example:
rs.Find "nvName = " & strMyName, 0, adSearchForward, 0
rs.Find "nvName=" & strMyName
[Here, the skiprows and start is by default 0 and the default direction is adSearchForward]
Cheers
- Status
