ByPassShift Key

[ismailr]

Hi Guru,

To BypassShift Key, I used the code given at below link in this forum;

http://www.access-programmers.co.uk/forums/showthread.php?t=51479&highlight=bypass+shift+key

I created a sample .accdb (the same is attached) and followed the steps. Then I converted the db into .accde but unable to get the expected output. I mean, if I hold the shift key and open the db it open and shows all objects.

Please guide me, if I am missing any step or part of codes.

Thanks
Ismail

 

[RuralGuy]

Does it work for you as an accdb?

 

[ismailr]

Thanks for quick response.

For both .accdb and .accde shows correct behaviors first time but if user open subsequently with shift key, it shows all objects.

Ismail

 

[RuralGuy]

Hmm...I see the issue now. Will do some investigating and get back to you.

 

[arnelgp]

you should call it with False as parameter.

 

[RuralGuy]

You need to backup before you make changes or you will lock yourself out of the db. There is a way to fix it though! The BypassKey(False) need *only* be executed once (from the immediate window) and not every time the form loads. This code works just as I would expect. ARNELGP is correct that the argument should be (False) to disable the AllowShiftKey Property.

 

[RuralGuy]

Here's a link to the solution if you lock yourself out.
http://www.kallal.ca/msaccess/msaccess.html