Shift key button

[vb_Dumb]

i was wondering if there was a way to have a button that when you
pressed it it would prompt you for a password and then enable or
disable the shift key bypass

 

[Douglas J. Steele]

Sure.

You need

CurrentDb.Properties("AllowBypassKey") = False

to disable using the shift key, or

CurrentDb.Properties("AllowBypassKey") = True

to enable it.

Note, though, that that will not take effect until after you shut down the
database and reopen it.