T
tracktraining
Hi All,
Can anyone tell me how to suppress the SHIFT key bypass?
Thanks,
Tracktraining
Can anyone tell me how to suppress the SHIFT key bypass?
Thanks,
Tracktraining
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Klatuu
Define suppress.
What is it you want to do?
What is it you want to do?
T
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.
bypassing the start-up setting.
K
Klatuu
M
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
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
D
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".
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".
M
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
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
K
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>
I am confident that if I post something that is incorrect, Doug will
politely and correctly straighten me out. <g>
T
tracktraining
thanks Mike, Doug, and Klatuu for helping out. I will try that code.
T
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
code in correct? it will not affect MS Access?
-Tracktraining
T
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!
call that function and where to call it in my db.
Any help please?
-Thanks!
D
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
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
T
tracktraining
THANKS! it works!
--
Learning
--
Learning
Douglas J. Steele said: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
K
Klatuu
Correct
tracktraining said: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