Results 1 to 2 of 2
  1. #1
    cassidym is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    44

    Make Table Warning Message

    How do I stop the warning message that appears every time I run a Make Table query?



    Whenever I run the Make Table query, a message appears stating, "You are about to run a make-table query that will modify data in your table. Are you sure you want to do this?"

    How do I stop this message from appearing? I want my user to just click the button in the Switchboard that runs a macro that runs a make table query that then open the new table for the user to edit. And I don't want my user to have to read and accept all these warnings.

    Thanks

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Look at DoCmd.SetWarnings I have Acc2003. It's available in vba.
    You would need some code in the OnClick event.

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

Similar Threads

  1. Replies: 3
    Last Post: 12-06-2010, 04:06 PM
  2. Warning Message for Missed Date
    By maintt in forum Access
    Replies: 2
    Last Post: 07-23-2010, 09:05 AM
  3. Access warning message
    By John Southern in forum Access
    Replies: 2
    Last Post: 05-28-2010, 06:01 AM
  4. warning to make update note
    By ga3la in forum Access
    Replies: 1
    Last Post: 01-30-2010, 09:51 PM
  5. Records deleted with NO warning message.
    By evanscamman in forum Access
    Replies: 2
    Last Post: 12-14-2007, 11:18 PM

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