Need to supress popups and error messages

[johnawebbhsd]

I have a module that is running several macro's, which in turn are running table-select queries. These queries generate pop-up messages before creating overwriteing etc... I need this module to run at a particular time with no human action.

Does anyone know short code to 1 supress messages and 2 allow module to run at XX:XX time of day?

Thanks for all of the help.....

 

[mdmilner]

I have this feeling this is an incomplete list but:

Under Tools-Options-Edit/Find you can find check boxes to turn off some confirmations for action's. You can turn off updates to forms or even the screen for any MS application.

This does it for an xls Workbook for example...it's commonly used at the beginning of a procedure and turned back on at the end with an = True

Application.ActiveWorkbook.ScreenUpdating = False

Unfortunately, that I know of, Access does not have any time based batching capabilities, unlike a product such as SQL. The closest you're going to get would be to use MSTask to open a MDB that as it's startup action it executes a form and/or procedure via a form.

There are a few examples of doing this out there that I've found, but I've never gotten past the research stage of investigation.

Try here:
http://www.mvps.org/access/

Mike

 

[johnawebbhsd]

that was what I needed. That command works great...

Thanks

 

[bat17]

Forms have a Timer event that can be used to run code/macros. the form has to be open to work but does not have to be visible. If you look up "Timer Event" in help you should be able to find examples of how to do this.

You can use
DoCmd.SetWarnings False/True
to turn warnings on and of from code, this is preferable to pemantly turning them off from otions, Warning can be usefull at times

If you are running long queries you may also find
DoCmd.Hourglass True/False
useful as well

HTH

Peter