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

[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

 

[Douglas J. Steele]

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