Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Unanswered: Surpressing Update Confirm Dialogs in Access 2000?

    I am currently building a front end to a DB in VBA to do some quick alterations of data. Everytime I run a SQL UPDATE in the code, I get prompted with an annoying dialog box to confirm the updates. Is there any way to surpress this or a better way to directly alter a record?

    Thanks...

  2. #2
    Join Date
    Jun 2004
    Location
    Terrapin Nation
    Posts
    205
    Docmd.setwarnings false
    ''code to run your update query
    Docmd.setwarnings true




    Or you can use macro's to set warnings on/off.

Posting Permissions

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