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

    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?


  2. #2
    Join Date
    Jun 2004
    Terrapin Nation
    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