Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Aug 2002
    Location
    Des Moines, Iowa, USA
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Seek - How to use (XP)

    I have a VBA program which I am trying to use the Seek method on a recordset using multiple values. I did some research and found Seek Array, but have not had any luck getting it to work properly. Any and all suggestions are appreciated.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Seek - How to use (XP)

    Can you give us the code you have used so far, so we can see what is going wrong ?
    Francois

  3. #3
    Star Lounger
    Join Date
    Aug 2002
    Location
    Des Moines, Iowa, USA
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Seek - How to use (XP)

    Just prior to leaving for lunch, I discovered my oversight. Microsoft's Knowledge Base Article Q243465 stated that I needed to make sure that under Tools/References (on the VBA screen) I had selected Microsoft ActiveX Data Objects 2.1 Library, and Microsoft ADO Ext. 2.1 for DDL and Security. Making sure that these two objects were selected, along with using the Array construct within the Seek method, (also demonstrated within the article) got me on my way. Thank you for your time.

Posting Permissions

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