Re: suppress SHIFT key

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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
--
Learning


"Klatuu" wrote:

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>

"MikeJohnB" <MikeJohnB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7E44F7EF-574C-4381-B630-0F8509618E87@xxxxxxxxxxxxxxxx
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
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"Douglas J. Steele" wrote:

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".

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"MikeJohnB" <MikeJohnB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FE58ED20-2DB5-4E4F-8E11-FC36B2341EC5@xxxxxxxxxxxxxxxx
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
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"tracktraining" wrote:

Hi All,

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

Thanks,
Tracktraining
--
Learning






.

Relevant Pages

  • Re: I am stumped....TimeValue problem
    ... this got to do with my start and end of shift times based on what ... afternoon at work working on the database, ... I opened the database on the new computer the DLookup ... it for a time across midnight when Nowis past midnight and you may well ...
    (microsoft.public.access.formscoding)
  • Re: I am stumped....TimeValue problem
    ... Because it uses Recordset code, you may have to find a few references or the ... this got to do with my start and end of shift times based on what ... A Converted database sent to me by someone with a highter version of ... will be worked past midnight once it goes live where I work. ...
    (microsoft.public.access.formscoding)
  • Re: Recordset or Array to memory problem
    ... I have an Access 2003 database running on an XP network. ... The user enters shift codes into each shift field or leaves them blank ... Dim RosSftrst As Recordset ... "FROM RosterShifts", _ ...
    (comp.databases.ms-access)
  • Re: A Spy on MS Access - Please Help
    ... I do not press shift F2 in any of my text boxes. ... May I ask your help to guide me on how I can invoke autodialer and/or zoom ... I am using Access 2003 and I saw the utility in Project Explorer in VB ... the Project Explorer that there is another open database - ...
    (microsoft.public.access.modulesdaovba)
  • Re: I am stumped....TimeValue problem
    ... this got to do with my start and end of shift times based on what ... afternoon at work working on the database, ... I opened the database on the new computer the DLookup ... it for a time across midnight when Nowis past midnight and you may well ...
    (microsoft.public.access.formscoding)