Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Kendrick, Idaho, USA
    Posts
    277
    Thanks
    1
    Thanked 0 Times in 0 Posts

    ADO form recordset (2000)

    How do you do the following in ADO? It's part of a search routine used in 97 that must be converted to 2000. I do not have the luxury of referencing libraries. I know about opening a form w/ a criteria, but I'm not opening a form. I just need to get to the form's recordset in ADO.

    Dim rst as DAO.Recordset
    set rst = Me.RecordsetClone
    rst.FindFirst "Criteria"
    if rst.NoMatch Then
    Msgbox "No Match"
    Else
    Me.Bookmark = rst.Bookmark
    EndIf
    rst.Close


    Thanks for your help.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ADO form recordset (2000)

    You can't do it like that. And don't try to base an ADO recordset on a DAO recordsetclone because it won't work. Is there some particular reason why you have to do this in ADO? Access 2000 supports DAO and for somethings (like this), the DAO works better and faster. The DAO 3.6 library is installed with Access 2000, so the only reference you need is the one to that library. If you aren't allowed to set that reference, then you should hand the whole thing back to whoever gave it to you and tell them you can't work with one hand tied behind you.

    There is a "loosely" equivalent navigation method in ADO, but I haven't found it to be as reliable as the DAO version and only allows a single criterion--no AND allowed. You can get the details in MSKB Q195222.
    Charlotte

Posting Permissions

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