We help IT Professionals succeed at work.

How do we force an automatic sign off after a few minutes of no activity?

We have Access and Excel programs that are used by many employees in the office.  At times, some of them will leave the file open and go to lunch or minimize the file, forget about it and work on other files or projects which can hinders other users.  I would like a procedure that will 1) ask the user if they would like to continue to be signed on the program, 2) if they say no or if the program receives no answer to the question, the program will automatically save the file with all changes and close so that others may use it and 3) If the program is closed, a statement will be displayed on the screen saying that it was closed because of "No Activity".  The time-out test could be something like 15-minutes (more or less).  Any suggestions?  Since I have never made a program like this, please send the steps and state where they would be placed in the program.  Also, is there a "time-out" process already built in that can be used that I don't know about?

Thanks.
WRS
Comment
Watch Question

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007
Commented:
Here you go ... free - and it works:

http://www.peterssoftware.com/isd.htm


Related:

http://www.peterssoftware.com/fsd.htm

mx
Top Expert 2012

Commented:
Removed cause other answer was better

Author

Commented:
Thank you DatabaseMX for your suggestion on forcing a file to shutdown if a user leaves the file open and makes no changes for a 15-minute period.  The programs looks great and it appears to be a perfect system to do what we want done.

However, I work in a high security federal government building where outside or external programs and systems are blocked and not allowed to work or download.

I will keep this program available for people who need this shutdown ability but are not located in a system that has extra security protection.

Do you have a suggestion on how a file can be shut down after no activity?  The steps need to be part of the Access or Excel file or program using the installed keys and the built-in controls.

To: xDUCKx, please write the suggestion that you were going to attach but changed your mind after you read the program sent in by DatabaseMX.  I agree that that program seems to be very, very good but I must find another way to accomplish the shut down.

Thanks again.

WRS
Here's a start with several customizations. I hope it fits your needs.

http://www.vbaexpress.com/forum/showthread.php?t=33711

Open in new window

Thanks Techfanatic,

I have asked the computer security office to determine if it is ok for me to use this process.  I will reply soon.  Thanks.

WRS

Author

Commented:
Good news.  Our managers have determined that the suggestions given by DatabaseMX and Techfanatic may be used for various programs in the office.  I am, therefore, awarding the points to both experts.  Thank you for your assistance.

WRS

Author

Commented:
Thank you for your assistance.  Both solutions from  techfanatic and DatabaseMX have been approved as working solutions in our office.  They must be reaproved each time that they are considered for used.  They do answer the pending question.  

We want to also thank Experts-Exchange for providing a means for us to get the information that we need.

WRS
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Cool.

Author

Commented:
We have a problem using outside programs in this governemt office because of the security requirements.  However, our office along with security have determined that both of these programs may be use under certain controlled circumstances.

Thank you for your assistance.

WRS

Explore More ContentExplore courses, solutions, and other research materials related to this topic.