sleep function

[Dan Gaecklein]

I want to create a sleep function which lets me run a routine, stops it for
the amount of time I specify, then continue on.
I have tried a couple of different methods without success. Thanks.

 

[Steve Schapel]

Dan,

The only way I can think of with macros, is to split the macro into two
macros, being the actions that take place before and after the delay.
Then, at the end of the first macro, use an OpenForm action to open a
form (hidden possibly), whose Timer Interval property is set to the
amount of time you want the delay (or else you can use a SetValue action
to adjust the amount of time from within the macro). And then, the
second macro is assigned on the Timer event of this form. And at the
end of the second macro, a Close action to close the form again.