Re: Self closing DB
Tech-Archive recommends: Fix windows errors by optimizing your registry
hi Luis,
Luis wrote:
I have a database that i need to close after working hours.
The idea i'm thinking is to create a process that checks the hour and if its
between 11pm and 12pm the database closes.
Use a hidden form with a timer event. Check the time in the event and
close the database.
But i don't understand your problem: why are your computers running when
no one sits before them?
mfG
--> stefan <--
.
Relevant Pages
- Re: A more difficult scheduling question
... Create a form in your ACCESS database. ... Call it frmScheduler. ... (This will make your timer event run every 2 minutes.) ... open an ACCESS database that has an AutoExec macro that runs ...
(microsoft.public.access.macros) - Re: Importing files when updated automatically.
... > I have created a database which, amongst many other things, imports ... Can you count on the database to be open at whatever time the import ... you could use the Timer event of a form ... external scheduler routine to open the database, and if you do that, the ...
(microsoft.public.access.modulesdaovba) - Re: Code window Crashes!
... I do not have a timer event on any ... First experiment is to try to launch your database while holding down ... Then switch to VBA and try to enter something. ... Compact the database to get rid of this junk: ...
(microsoft.public.access.modulesdaovba) - Forms on WEB page in MS Access
... My name is Henrik and I reading a forum about "On Timer event". ... updates a text box every 120 seconds or so. ... The text box is connected to a field in a database ...
(microsoft.public.access.formscoding) - RE: Message popups up
... So I may be asking too much, but I'm a little lost on the Timer Event. ... specifically to their entries in the database (probably not the correct way ... Autoexec that runs a function that opens your form, ... whatever form they need positioned on the record that needs attention. ...
(microsoft.public.access.modulesdaovba) |
|
