Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / April 2005

Tip: Looking for answers? Try searching our database.

Set timer for invisible form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ChrisBat - 09 Apr 2005 11:37 GMT
(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  
John Vinson - 09 Apr 2005 18:55 GMT
>(also posted in the Access forms newsgroup)........
>Hi,
[quoted text clipped - 10 lines]
>at c dot battiston at bell dot ca, as I will not have a chance to log into
>this site tomorrow morning.

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]    
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.