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

    Access VBA (97/2000)

    Generic question - I have been told that one should avoid bookmarks. Is there a basis to this?

    Thanks

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

    Re: Access VBA (97/2000)

    Sorry, but in Access that question is so vague it is virtually meaningless. Bookmarks where and used how? Bookmarks are useful when you move within a recordset and want to be able to move back to the same record. They are not useful between recordsets, since the recordsets are not necessarily synchronized..
    Charlotte

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access VBA (97/2000)

    Generic answer - there is NO reason to avoid them.

    However, you do need to understand how they work, since they can be misused. I'm guessing the person who gave you this "advice" didn't understand, and got burned.

    There are really only 2 things you need to know. As Charlotte mentioned, you can't use bookmarks between 2 recordsets, even if they were created identically (exception, a form's recordset and its recordsetclone). And any time you requery a recordset, the bookmarks are recreated; that is, a bookmark saved before a requery is no longer valid.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Access VBA (97/2000)

    Sorry the question was so vague - I was passing on a question I didn't understand, either. Thank you for your responses and I'll pass them back.

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

    Re: Access VBA (97/2000)

    Maybe the source of his concerns is this KB article :
    Data Changes Are Saved to the Incorrect Record (Q191883).
    If he have Access 97 and applied SP2, it should be OK
    When you have been bitten by these, you don't forget.
    Francois

Posting Permissions

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