Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Disabling Undo on Update Query (Access 2000)

    When I run an update query I get an message that if I want to continue I will loose the option of undo. How do I disable this message?

    Thanks

    Mario

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Disabling Undo on Update Query (Access 2000)

    This message means that you are running out of memory.

    If you run the query manually, I don't think you can suppress the message.
    If you run it from code, you might put
    DoCmd.SetWarnings False
    before the instruction that runs the macro, and
    DoCmd.SetWarnings True
    after it.

    But it might be dangerous to suppress warnings like this.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Disabling Undo on Update Query (Access 2000)

    Thanks I will use your code.

    Mario

Posting Permissions

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