The SHIFT key

[Anthony]

Is there a way to make access ignore the recognition of holding down the
SHIFT key while access loads a database?

 

[Alp Bekisoglu]

From the menu in access:
Tools > Startup...
then click Advanced>>, and uncheck Use Access Special Keys

Alp

 

[Rick Brandt]

From the menu in access:
Tools > Startup...
then click Advanced>>, and uncheck Use Access Special Keys

The shift key is not affected by that setting. You need to alter a database
property (AllowBypassKey) with code to disable the shift key. The help file
explains how to do this.

 

[Anthony]

that doesn't work

there's no "Advanced" button or menu

and I uncheck "Use Access Special keys" and I'm still able to bypass startup
things by holding down the SHIFT key.

please help

 

[Anthony]

(I could not find property: "AllowBypassKey", but I did find
"AllowSpecialKeys")

So should the code look like this?

Sub mySub()

Dim db As Database
Set db = CurrentDb
db.Properties("AllowSpecialKeys") = False
set db = Nothing

End Sub

 

[Douglas J. Steele]

The AllowBypassKey property doesn't exist unless you create it.

Use the code from http://www.mvps.org/access/general/gen0040.htm at "The
Access Web". Copy that code into a new module, then run the following from
the Immediate Window (Ctrl-G):

ChangePropertyDdl "AllowBypassKey", dbBoolean, True

It's not even necessary to save the code. I'd advise keeping a copy of the
database that you don't do this to, though, just in case something goes
wrong...

 

[Anthony]

that still doesn't work.

I pasted the code into a new module, and execuited the line:

ChangePropertyDdl "AllowBypassKey", dbBoolean, false

but I'm still able to use the SHIFT key and bypass startup items.

Please help - thanks

 

[Anthony]

nevermind i got it working, thank you

that still doesn't work.

I pasted the code into a new module, and execuited the line:

ChangePropertyDdl "AllowBypassKey", dbBoolean, false

but I'm still able to use the SHIFT key and bypass startup items.

Please help - thanks