|
-
September 8th, 2001, 12:04 AM
#1
Using Find Method with multiple criteria
I' tryring to use FIND METHOD (ADO) keeps giving me
RunTime Error "3001"
Argument are of the wrong type, are out of acceptable range, one are in conflict with one another
I've tried various techniques still no luck. Is it a BUG or not possible to use this method with multiple criteria using AND
anybody know's the systax.?
dim xstring as string
xstring = "Colom1='13' AND Colom2='XX'" (failed)
xstring = "(colom1='13' AND colom2='XX')" (failed)
xstring = "colom1='13 " ' " AND "colom2= ' XX " ' " (failed)
xstring = "colom1 like '13' AND colom2='XX' " (failed)
the final Syntax:
rs.find xstring, 0, adSearchforward, 1
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|