Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Toronto, Canada

    Angry Unanswered: Closing Access2000 Application When Not Used

    Hello ,
    i have an Access2000 application that i placed on a shared drive. The problem is that people leave it open and go home until the next day. I have advised them to close it when they are not using it. How an i place a timer to close the form 30 minutes when not used.
    Any help would be appreciated. I am sure i saw something a while ago .

  2. #2
    Join Date
    Jun 2004
    Birmingham, UK
    I think that this is the basic sort of thing you are after

    What you can do is create a non visable form, this should be opened automaticaly by your database on startup.

    Set the timer property to 30min and use the 'on timer' event to close the database ('docmd.quit') if the system time is greater that some value you have decided.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts