Time Interval

[klwu]

Hi,

I have another question. I want to make one of my page refreshes every 5 minutes, I have already wrote the code for the Timer(), but how do I set the Time Interval? I don't know how to calculate that one. Thanks!

 

[ColinEssex]

a quote from Access help

"For example, to requery records every 30 seconds, put the code to requery the records in the form's Timer event procedure, and then set the TimerInterval property to 30000."

Col

 

[ksiv]

1 second equals to 1000

also you can write the timerinterval in VBA
private sub form_load()
me.timerinterval=300000
end sub