PDA

View Full Version : How to avoid turning-off warnings in a timer event making warnings appearing when oth



PP1918
10-17-2019, 07:03 AM
I want to run an append query on a form's timer event and will turn warnings off just before running it and turn them on just after running it.
If the timer is called while some other code is running (e.g. as a result of the user pressing a button), will that code then have warnings appearing on screen and can this be avoided? Thank you!

Logit
10-17-2019, 07:51 AM
.
http://www.excely.com/excel-vba/disable-alert-warning-messages.shtml

OBP
10-17-2019, 10:08 AM
I am fairly certain that once the Timer event starts running and the warnings are set to off then no warnings will occur until the query runs and the timer event turns them back on.
Unless of course the other code sets the warnings to on.