 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Macros / October 2007alerts in macro's
when using an append query in a macro, how can you hide the alerts or dialog boxes or make them automatically click yes For first action use Warnings - Off. Then for last use Warnings - On.  SignatureKARL DEWEY Build a little - Test a little > when using an append query in a macro, how can you hide the alerts or dialog > boxes or make them automatically click yes Can you please put that in "stupid user" terms? I have been using macro's sporatically and am currently drawing a blank on how to translate your response. Thanks in advance for your patience. > For first action use Warnings - Off. Then for last use Warnings - On. > > > when using an append query in a macro, how can you hide the alerts or dialog > > boxes or make them automatically click yes See Steve Schapel's response. SignatureKARL DEWEY Build a little - Test a little > Can you please put that in "stupid user" terms? I have been using macro's > sporatically and am currently drawing a blank on how to translate your [quoted text clipped - 4 lines] > > > when using an append query in a macro, how can you hide the alerts or dialog > > > boxes or make them automatically click yes Desiree, Put a SetWarnings/No action in your macro before the first OpenQuery action. SignatureSteve Schapel, Microsoft Access MVP > when using an append query in a macro, how can you hide the alerts or dialog > boxes or make them automatically click yes Desiree- Whenever you "turn off" system warnings, as has been correctly suggested, it's also a good practice to create your own error handling. You might want to put a DCount statement as a condition one line below the append query in the same macro to validate the record was added to your table and have the condition=true fire your own message box, then set warnings back on. The last thing you want is for a user to "think" a record appended when it really didn't (they wouldn't know BECAUSE the warnings were turned off!) ... just a thought from someone that's written several proprietary Access applications. >when using an append query in a macro, how can you hide the alerts or dialog >boxes or make them automatically click yes |
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.