Disable Shift key during startup

[vmolasi]

Hello there,

Can someone advise me on how to disable the Shift key during a Database startup. I have some idea about the fact that AllowBypassKey property has to be set to False. However, as it is not a standard property of the DAO database object type, it has to be first created, attached to the DAO database object and the set to the desired value.

I am really struggling with the VBA code to achieve this.

Thanks

 

[Maquis]

I've written a few faqs that cover this. You may also want to disable a few other options if your goal is to keep users out of design view.

Check out faq181-1021 for a way to do this without code.

And faq181-1172 for a way to do it with VBA.

Maq
<insert witty signature here>

 

[vmolasi]

Thanks a lot Maquis, the FAQ with the VB code has made my day.

Cheers

 

[vmolasi]

Hello Maquis,

I implemented the code, and made the necessary changes. I put specified my opening form and also my login code and have setup for the function to be executed via the Autoexec function in a Macro. However when I open the database, it soes not ask for my login id and goes straight to the opening form with the backend blocked.

Could you tell me wher am i wrong

Cheers

 

[Maquis]

Vmolasi,

My code doesn't prompt you for a login. It doesn't use Access security, but instead pulls your login id from the Windows userid or Network login.

Maq
<insert witty signature here>