3 functions to run at specific times...possible?

  • Thread starter Thread starter Huh
  • Start date Start date
H

Huh

Hi:

I have three functions in AC2003 that I want to run at specific intervals
and specific durations:

functions01 run every 15 minutes for 5 minutes (hh:12, hh:27, hh:42,
hh:57)

functions02 run every 15 minutes for 2 minutes (hh:18, hh:33, hh:48,
hh:03)

functions03 run every 15 minutes for 5 minutes (hh:21, hh:36, hh:51,
hh:06)

where hh is the current hour.

Is something like this possible?


thanks
 
You could write code that's an infinite loop. Inside the loop, use
Minute(Now) to see what the minute is. I don't understand, though, what you
mean by running a function for a specific length of time.

Make sure you put DoEvents statements into your code to ensure that your
loop yields execution so that the operating system can process other events
 
Back
Top