 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / August 2006What triggers the Delete Warning message box?
What triggers the Delete Warning message box and how do I get rid of it? >What triggers the Delete Warning message box Running a Delete query, or some other action which will delete records from a table in your database. What are *you* doing right before you see the message? >and how do I get rid of it? Are you certain that you want Access to permanently, irrevocably, and silently delete data from your database without any warning? John W. Vinson[MVP] I am providing my own customized warning and want to suppress a second warning. I am doing nothing other than allowing the user to press the Delete key and processing other deletes (of related records) myself via EXECUTE. > >What triggers the Delete Warning message box > [quoted text clipped - 8 lines] > > John W. Vinson[MVP] >I am providing my own customized warning and want to suppress a second >warning. I am doing nothing other than allowing the user to press the Delete >key and processing other deletes (of related records) myself via EXECUTE. The Querydef Execute method (qd.Execute "MyDeleteQuery" for example) will not issue any prompts; or you can use DoCmd.SetWarnings False prior to running the delete. Be sure to DoCmd.SetWarnings True afterward or you'll turn off ALL warning messages for the rest of the Access session! John W. Vinson[MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.