Prevent user by pass autoexec by pressing shift key

[Tim]

Hi folks,

Is there a way to prevent user by pass autoexec macro by
pressing shift key? Or assign other key such as F12 to
replace the shift key function (By pass autoexec macro)?

Thanks a lot.

Tim.

 

[Steve Schapel]

Tim,

This can't be done with a macro. There is information regarding VBA
procedures for this purpose at
http://www.mvps.org/access/general/gen0040.htm