suppress SHIFT key

[tracktraining]

Hi All,

Can anyone tell me how to suppress the SHIFT key bypass?

Thanks,
Tracktraining

 

[Klatuu]

Define suppress.
What is it you want to do?

 

[tracktraining]

I don't want the user to be able to press SHIFT key and open the db and thus
bypassing the start-up setting.

 

[Klatuu]

Try this utility. It really works pretty well

http://www.jamiessoftware.tk/propeditor/pe_jump.html

 

[MikeJohnB]

you can also suppress the shift key bypass in the >>tools/startup<< options,
untick allow access special keys. Be careful, not even you will be able to
shift bypass the opening database though and you should retain a master copy
on which the option is not set. This option is best used on front end back
split databases where the front end issued to the users has this option
unticked, your copy doesn't.

For Access 2007, this option can be found from clicking the windows globe,
top left of the open database screen, select Access Options at the bottom of
the popup menu, select current database and set or unset the options you want
to allow the users to be able to access on the form you use as the startup
form. The startup form is also nominated in this area.

However, if you have disallowed menus, I would have thought you would have
been using this area so perhaps I'm barking up the wrong tree as some say????

Regards

 

[Douglas J. Steele]

I don't believe that's correct, Mike.

To suppress the shift key bypass, you need to create a database property
named AllowBypassKey and set it to False. The proper way to create the
property is shown in http://www.mvps.org/access/general/gen0040.htm at "The
Access Web".

 

[MikeJohnB]

You know something Douglas, you are absolutely right, I tried it on a spare
database I have, I have thought that not allowing Special Keys prevented the
shift key option for some time. However, I normally test before posting so I
guess I ought to re-start that before replying. Confidence now in tatters.

Thanks for putting me right though.

Cheers, have one on me.

Mike B

 

[Klatuu]

Actually, this should enhance your confidence.

I am confident that if I post something that is incorrect, Doug will
politely and correctly straighten me out. <g>

 

[tracktraining]

thanks Mike, Doug, and Klatuu for helping out. I will try that code.

 

[tracktraining]

by the way, the suppress SHIFT code will only affect the db that I have the
code in correct? it will not affect MS Access?

-Tracktraining

 

[tracktraining]

sorry for asking/making so many comments.... but I don't understand how to
call that function and where to call it in my db.

Any help please?

-Thanks!

 

[Douglas J. Steele]

That function doesn't actually have to be included in your application: it's
a one-time action you need to do.

You might find it easier to download Albert Kallal's By Pass Shift Key Code,
about half-way down the page at
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[tracktraining]

THANKS! it works!
--
Learning

That function doesn't actually have to be included in your application: it's
a one-time action you need to do.

You might find it easier to download Albert Kallal's By Pass Shift Key Code,
about half-way down the page at
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[Klatuu]

Correct

by the way, the suppress SHIFT code will only affect the db that I have
the
code in correct? it will not affect MS Access?

-Tracktraining