Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Posts
    1

    skip "run query anyway" message

    Hi,

    I have some append-query that I want to run in one macro. But after running each macro Access comes up with this error message saying that it didn't add a certain amount of records due to key violations. Then you have to click yes to execute anyway. My question is if I can add something in VBA to the macrocode to skip this errormessage and just always choose yes.



    Thanks in advance

  2. #2
    Join Date
    Aug 2008
    Posts
    8
    You need to add the following to the beginning of your module:

    Docmd.SetWarnings = False

    And this to the end

    Docmd.SetWarnings = True

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 09-05-2008, 12:07 PM
  2. "Overflow" error message.
    By joeferraro2000 in forum Queries
    Replies: 0
    Last Post: 03-08-2007, 06:36 PM
  3. Export to .rtf of "104-" converts to "-655&qu
    By Sherri726 in forum Import/Export Data
    Replies: 0
    Last Post: 12-19-2006, 03:16 PM
  4. Replies: 2
    Last Post: 08-31-2006, 12:19 PM
  5. "Count" and "Countif" in Reports
    By JMantei in forum Reports
    Replies: 1
    Last Post: 06-20-2006, 02:20 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums