I am trying to find a way to close MS Access at a set time. I currently use a hidden form to close access after it has been inactive for a set period of time. I need the ability to close it at a set time because I have not been very successful with making backups, it will not back up my database files because they are open.

Tony

You have to have a form open and running that has the timer property set.

On the Event tab of the form properties:
1) Set timer interval. Note: 1 second would be a value of 1000
2) Create an On Timer event procedure for the form. That procedure can check the time and exit the database at that time. Note: If the DB is opened on other machines you still may have the same problem even if you close it on your machine.

Thanks for the reply allenm

What code would I use to check the current time and compare it to the current time using VBA

Hi,

If you do this on the On Timer event:

First set the Form's Timer Interval property to some value, like 10000 to check the time every 10 seconds, or longer, then on the On Timer event, do this (adding your own time, of course):

Dim dtTime As Date

dtTime = TimeValue(Time)

If dtTime >= #8:20:00 AM# Then
    Application.Quit
End If


This is going to shut the app down at a specific time. It just shuts it down, so make sure you want to do this.

Did that help?


mmcdonal

Look it up at: http://wrox.books24x7.com

That was in the Access 2003 VBA Programmer's Reference, btw, Chapter 10 on Event Property and Procedure Examples.


mmcdonal

Look it up at: http://wrox.books24x7.com

Thanks for all the help :)