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!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADODB - Recorset - Find

Status
Not open for further replies.
Diogo

Diogo

Technical User
Mar 22, 2001
143
PT
Hello!

I would like to know, if there are someone that would like to help me.

The question is whow i it works then find command of a recordset from an ADODB.

Thanks for any whay.

Diogo Reis
 
Sort by date Sort by votes
rsYourrecordset.Find "YourField = '" & YourVariable & "'", , adSearchForward, adBookmarkFirst

David Paulson


 
Upvote 0 Downvote
You could also use >, <, >=, <=, <> or LIKE as the operator in the Find clause. However, the FIND method only supports one search condition. If you try to specify multiple search conditions using AND or OR keywords you'll get a run-time error. Use the FILTER property if you want to use multiple search conditions.

Herman :-Q
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
USE find instead to loop
Replies
2
Views
318
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
FIND ARRAY IN OTHER ARRAY
Replies
3
Views
249
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
FIND VALUE IN COLUMN 0 OF MSFKLEXGRID
Replies
0
Views
174
sal21
sal21
sal21
  • Locked
  • Question
FIND IN DICTIONARY WHITOUTH loop 1
Replies
4
Views
228
strongm
strongm
sal21
  • Locked
  • Question
find in a collection 1
Replies
5
Views
206
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top