Results 1 to 3 of 3

Thread: Find Record with ADODC

  1. #1

    Thread Starter
    New Member
    Join Date
    Jan 2000
    Location
    Australia
    Posts
    9

    Post

    I have been using DAO data controls in an application I am writing and upgraded to VB 6.0 so changed to the ADO data control.
    The database is Access 2000 and I have queries which are passed a number of arguments from VB.

    With DAO I used 'FindFirst' successfully but this is not available with ADO so I tried 'Find' but it will only allow one argument to be passed.
    With the ADO data control, how do I now return a record in an Access database via an Access query where more than one argument is passed?

  2. #2
    Addicted Member
    Join Date
    Oct 1999
    Posts
    253

    Post

    You cannot use ADO's Find method with multiple conditions. Instead, you can use ADO's Filter method or create a query.

  3. #3

    Thread Starter
    New Member
    Join Date
    Jan 2000
    Location
    Australia
    Posts
    9

    Post

    Thanks mate! I've got it now.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width