Countdown Timer that triggers macro at 0

  • Thread starter Thread starter pif_marcinko_
  • Start date Start date
P

pif_marcinko_

I am really just getting started in the world of VB and am having
difficulty acheiving what it is I want to do. I want to create a timer
displayed on a form that counts down from 96 hours. Example
96:00:00:00. When the timer reaches 0 I have a macro called "Send
Critical Report" that I want triggered. After the macro has been
triggered and then completed I would like to have the timer reset for
the next launch of reports in 96 hours.

I am sorry I am really green at this stuff but I have a good handle on
ACCESS, just very limited VB skills. I am trying to learn as much as I
can.

Many advanced thanks!!

Marcinko
Phoenix, AZ
 
Very bad approach!!!

You will be tieing up a great deal of your computer resources full time to do
this. Access will need to be running full time and the timer function (a hog on
resources) will need to be running full time. You would be much better off
investing a couple of bucks in an alarm clock!!
 
Why not use Windows Task scheduler tha launches an Access
application with the reports.

Jim
 
I am really just getting started in the world of VB and am having
difficulty acheiving what it is I want to do. I want to create a timer
displayed on a form that counts down from 96 hours. Example
96:00:00:00. When the timer reaches 0 I have a macro called "Send
Critical Report" that I want triggered. After the macro has been
triggered and then completed I would like to have the timer reset for
the next launch of reports in 96 hours.

I am sorry I am really green at this stuff but I have a good handle on
ACCESS, just very limited VB skills. I am trying to learn as much as I
can.

Many advanced thanks!!
Click to expand...

It would be better to use the AutoExec macro which automatically fires when the
app is launched and include a command to close the file afterwards. Then you
can just use the Windows scheduler to open the file at the appropriate times.
 
Back
Top