how to tell if a user tries to use the shift key

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

In a previous post i was able to find out how to stop a user opening my
database with the shift key held down
to bypass startup

I was wondering if there was a (simple-ish) way to tell if a user tries to
do this once i have turned this facility off?

thanks

Dave

ps i have tried to post this to two newsgroups at the same time,
i hope this is the correct method of doing this
please accept appologies and advise if not
 
Hi Dave,

You've disabled it. What does it matter?

Your objective is to disable users' ability to bypass startup, and you've
done it. Your users may well be holding down the Shift key, but it doesnt do
anything now. If you still dont want them to hold down the Shift key, tell
them so. Actually, tell them that the Shift key has been disabled so
pressing it is a waste of effort. I know they'll quit then.

You can check if the Shift key has been pressed, but why spend the
programming resources?


Immanuel Sibero
 
As far as I can tell, not with any built-in feature of Access or VBA. It
*might* be possible using the Windows API, I can't say for sure. If you want
to pursue that possibility further, a good starting point is the following
URL ...

http://www.mentalis.org/index2.shtml
 
Dave said:
In a previous post i was able to find out how to stop a user opening
my database with the shift key held down
to bypass startup

I was wondering if there was a (simple-ish) way to tell if a user
tries to do this once i have turned this facility off?
Click to expand...

It seems rather pointless, but if your application has a startup form
you could conceivably use the form's KeyDown event to determine if the
shift key is still held down when that form has been opened.
 
Back
Top