Results 1 to 2 of 2

Thread: ADO FIND METHOD

  1. Jun 25th, 2000, 11:00 PM #1
    BHostmeyer
    BHostmeyer is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 1999
    Posts
    81
    Can you pass more then 1 criteria using the find method..


    part_code = '01500' works but
    part_code = '01500' AND TYPE = 'A' DOES NOT WORK..

    any help would be appricated..

    Brooke
    -------------------------
    There is never only one right answer. That is the magic of programming.
    -------------------------
    Reply With Quote Reply With Quote
  2. Jun 26th, 2000, 01:32 AM #2
    BruceG
    BruceG is offline
    PowerPoster BruceG's Avatar
    Join Date
    May 2000
    Location
    New Jersey (USA)
    Posts
    2,657
    It appears as though you can't do it with the ADO Find method. I tried two examples, one with a single criterion, the other with an "AND", and it balked at the "AND" example. In looking at the Help topic on the ADO Find method, it says the criteria part must be a field, followed by a comparison operator, followed by a value - and it appears to be limited to just that. This behavior is unlike the DAO FindFirst, FindNext, etc. methods that DO accept multiple critera.

    I know this is not what you wanted to hear, but I gave it a shot and couldn't get it to go. Good luck.
    "It's cold gin time again ..."

    Check out my website here.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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