Results 1 to 3 of 3
  1. #1
    MarkA70 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2016
    Posts
    6

    Question MS Access 2010 System Messages


    Is there a way to suppress System Error messages. I have a form that I open for adding a record that is opened with the AcFormOpenDataMode set to 0 for adding records. I run a test on the BeforeUpdate form property that insures required fields are entered. Everything works great but after the test to insure a field is entered I get a system message 'There is no Current Record'. It makes no impact and all works well. However, the group I am doing this for is not too sophisticated and messages like this FREAK them out. Can it be turned off? THANKS!!!!

  2. #2
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You shouldn't get an error message after the BeforeUpdate event runs if you cancel the update when it fails validation. Something in code afterwards must be causing it.
    I guess you could turn off system prompts when this form opens, and turn them back on again when it closes. DoCmd.SetWarnings False might turn off the message you're getting, but it may be that the right fix would be to not cause the error at all.

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

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

Similar Threads

  1. Problem with access messages on queries
    By gstylianou in forum Access
    Replies: 9
    Last Post: 06-04-2014, 12:15 AM
  2. Replies: 0
    Last Post: 12-31-2012, 10:50 AM
  3. Suppressing Access messages
    By Reaper in forum Forms
    Replies: 1
    Last Post: 11-06-2011, 04:02 PM
  4. Custom messages to Access' default error messages.
    By evander in forum Programming
    Replies: 1
    Last Post: 06-26-2010, 02:06 AM
  5. SENDING EMAIL MESSAGES DIRECTLY FROM ACCESS
    By Frenchos in forum Access
    Replies: 0
    Last Post: 07-20-2007, 12:51 AM

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