Set timer for invisible form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top