[AccessD] Lock-screen inside an Access app

The issue here is "minutes of inactivity".  In order to measure time in
Access a form somewhere has to be running a timer.  

There is absolutely nothing AFAIK built in to Access that "measures
activity".  In order to measure activity... You have to define activity.
Mouse movements?  Keystrokes?  These are the two most common.  Keystrokes
are fairly easy, you intercept the key down and set a "last activity time"
global date variable.  Mouse movement however is much harder.

For that you will need a framework which uses class wrappers around forms
and controls (or at least the form).  Having that you can sink the mouse
move event for the form and controls and set the same global "last activity
time" global date variable.

Having a "last activity time" variable you can now use that timer tick I
mentioned in the second sentence to see how long since the last activity.
 
All in all not a 10 minute project, but it is doable.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Thursday, May 03, 2007 7:53 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Lock-screen inside an Access app

A friend asked me how he could put a Windows-like screen lock (that asks for
a password) inside an Access app. He's thinking that it's a hidden form that
then appears after x minutes of inactivity and wants a password before
letting the user back into the app. Presumably it would shut the app down
with no valid password.

Does anyone have an idea how to do this?

TIA,
Arthur
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com