Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2016

    Unanswered: How to disable Access Prompt when a record is changed

    How do you implement this code "DoCmd.SetWarnings False" in order to shut off the access prompts/warnings in MS Access 2010?
    You use the VBA do accomplish this right?

    I did go to / access options - advanced - confirm / and uncheck those boxes there, however, it did not have any effect on anything.

    Does anybody have another method of doing this?

  2. #2
    Join Date
    Jun 2016
    Can I just shut off this warnings for a specific form? Would I go to VBA and to the form I want to change and go to insert module or insert procedure? How would I specifically input the code into the VBA?

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    the normal way to use the set warnings macro is to turn warnings off, do whatever it is that was throwing the warnings, then turn 'em back on
    turn 'em off in perpetuity in the form / report but harden your code so that it is fault tolerant ie instead of warning take appropriate action

    but be warned turning off warnings isn't the panacea many think it is. having turned warnings off your code can become like a sullen teenager, sit there and do nothing, not tell you anything and and not responding.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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