[AccessD] Lock-screen inside an Access app

Mark A Matte markamatte at hotmail.com
Thu May 3 10:45:03 CDT 2007


I can't find the 1 I had...but here is a similar 1.

Thanks,

mark

http://www.access-programmers.co.uk/forums/showthread.php?t=103278


>From: "Mark A Matte" <markamatte at hotmail.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: accessd at databaseadvisors.com
>Subject: Re: [AccessD] Lock-screen inside an Access app
>Date: Thu, 03 May 2007 15:12:58 +0000
>
>Arthur,
>
>There is a sample db floating around somewhere that does the
>inactivity...the password part can be easily added.  I'll see if I can find
>it.
>
>Thanks,
>
>Mark A. Matte
>
>
> >From: "Arthur Fuller" <fuller.artful at gmail.com>
> >Reply-To: Access Developers discussion and problem
> >solving<accessd at databaseadvisors.com>
> >To: "Access Developers discussion and problem
> >solving"<accessd at databaseadvisors.com>
> >CC: "asanga at xplornet.com" <asanga at xplornet.com>
> >Subject: Re: [AccessD] Lock-screen inside an Access app
> >Date: Thu, 3 May 2007 08:33:56 -0400
> >
> >Thanks, JC. My friend is an occasional visitor to this group, and has 
>been
> >here enough to know some of the more frequent names. I told him when he
> >asked that you and/or Shamil would know how to do this. I'm forwarding 
>your
> >message to my friend now.
> >
> >I'm not sure how, in the absence of an entire framework, he should create
> >the wrappers for mouse-move and click, but maybe the keydown will be 
>enough
> >for his requirements.
> >
> >So it would work something like this?
> >
> >Form is hidden. Timer sees no keystrokes for say 10 minutes, then makes 
>the
> >form visible in dialog mode. Counts password attempts to three. If still 
>no
> >valid password, then Application.Shutdown; else hide the form and let the
> >user proceed.
> >
> >I'm a tad concerned about the timer continuing to operate while the user 
>is
> >using the app. Won't it interfere with things? On the other hand, I can't
> >think how else it might work, since the user could conceivably walk away
> >leaving the cursor in the middle of some field while he was adding a new
> >customer or something.
> >
> >Arthur
> >
> >
> >On 5/3/07, JWColby <jwcolby at colbyconsulting.com> wrote:
> > >
> > > 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
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
>_________________________________________________________________
>Need a break? Find your escape route with Live Search Maps.
>http://maps.live.com/default.aspx?ss=Restaurants~Hotels~Amusement%20Park&cp=33.832922~-117.915659&style=r&lvl=13&tilt=-90&dir=0&alt=-1000&scene=1118863&encType=1&FORM=MGAC01
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Download Messenger. Join the i’m Initiative. Help make a difference today. 
http://im.live.com/messenger/im/home/?source=TAGHM_APR07




More information about the AccessD mailing list