AutoExec

[TMSpurr]

We have a macro that we need to auto execute so the macro
runs at 2AM. However, there are times when we need to get
into the db without it executing. We know to hold shift
so macro doesn't start. However, we would like to
initiate some sort of WAIT or UserInput statement via the
macro that states if the program receives no other
instruction, to start the autoexec within some time period
(30 seconds or so). We have opened this db, as well as
others, and executed the macro much to our dismay. We've
looked and can't find anything and probably don't know
what it's called. Please Help. Thanks.

 

[TMSpurr]

I don't get feedback sometimes, so if there is no way to
do this "halt" or "pause" feature, let me know. If there
is someplace I should look for direction, please let me
know. I really need some help with this. Thanks! T

 

[Steve Schapel]

T,

It seems to me the most reliable approach would be to have the user
confirm the running of the macro. For example, instead of the macro
auto-executing, what you autoexecute is popping up a little unbound form
that has a command button labelled 'Run Macro' and another one labelled
'Use Database' or some such, and your macro itself is assigned on the
Click event of the first command button. Any good?

 

[TM+++++]

Steve, thought of that, but we need the process to run
automatically while everyone is not at the office to
reserve resources. Access doesn't have any type of halt
or pause or delay feature? Should be an item to add to
your list of suggested improvements? Any other thoughts?
Would really like a solution to the problem. BTW, you
guys do a really great job and wanted to let you know that
I appreciate all the help you give me, not that I ask a
lot of questions, but you're pretty great and helping when
we need it.

 

[Steve Schapel]

TM,

In that case, I would suggest using Windows Task Manager, or some other
third-party scheduling utility, to run it at the required time.