Set timer for invisible form

[ChrisBat]

Hi,

I have a form that, on startup, runs code that imports data from a dbase
application. Because we use the dbase for order creation, and the access
database for analysis, I need to refresh the data constantly (every 45
minutes would be ideal). The form that I have opening on Startup is
invisible, because I don't want my endusers to access it (obviously, which is
why it's invisible...sorry, too much Coke and not enough sleep.....).
However, I would like the code for the SetTimer function to run off this
form; does anyone have any idea as to how this can be done? Would anyone
that has an idea (or point me in the direction of a solution) please email me
at c dot battiston at bell dot ca, as I will not have a chance to log into
this site tomorrow morning.
Thank you very much in advance. You may have just saved my job (OK, a wee
bit of exaggeration, but again - too much coke and not nearly enough
ZZZZs....)
Later
Chris



Expand AllCollapse All

 

[Van T. Dinh]

Check Access VB Help on the Timer Event and TimerInterval Property of the
Form.

Since Timer Interval is in millisecs, you will need to set it to 2 700 000
for 45 mins.