How to Set up timer in Code???

[jane30]

Hi, I have a pretty complicated automation process. So, I created several timer forms to set the time interval between the procedures. But I think it seems very confusing there are so many timer forms in my Access 97 db. Is it possible to specify the time interval in Code, instead of using timer form?

Thank you very much for your time & help.

 

[genomon]

Ive never tried this (just popped into my head), but couldn't you set Me.TimerInterval to a global variable instead of a constant, then populate the value with the timer event in a global "master" module? Just a passing thought...

 

[jane30]

I'll give it a try! Thanks alot