Set timer for invisible form

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

Guest

(also posted in the Access forms newsgroup)........
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
 
(also posted in the Access forms newsgroup)........
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.
Click to expand...

Ummm... just set the Timer property to 2700000 (milliseconds, 45
minutes) and set the OnTimer event to launch the query.

The code will run whether the form is visible or not.


John W. Vinson[MVP]
 
Back
Top