In order to prevent inexperienced users corrupting the design of the Forms, Reports etc. of my Access DB, I have unselected the relevant options at Tools – Startup and it doesn’t display the Objects window. However, I find that when I press F12 key, a pop up window appears with ‘Save As’ ‘Save ‘frm……’ To: As …..’ with OK and Cancel buttons. Though a user can save the form with a different name and this does not interfere with the proper functioning of the DB, I find this an irritant pop up window. Is there a way to stop this pop up window?
Stopping pop up window of F12 key
- Thread starter gear
- Start date
Bilbo_Baggins_Esq
Registered User.
- Local time
- Today, 13:46
- Joined
- Jul 5, 2007
- Messages
- 586
Well, this won't directly answer your question, but I might be able to steer you in a productive direction.
Back before I knew much about access, the guy who wrote the producton database did the same thing as you for start up.
that was fine until word circulated that you could bypass the start up disabled features simply py pressing and holding the SHIFT key until the database was fully opened.
All menus and code were fully exposed by that means.
So he then wrote some VBA code built into the start up that entirely disabled the ability to bypass with the shift key.
Now what that code was, I do not know, but I would imagine whatever it was, MAY also be applicable to your F12 key question.
Back before I knew much about access, the guy who wrote the producton database did the same thing as you for start up.
that was fine until word circulated that you could bypass the start up disabled features simply py pressing and holding the SHIFT key until the database was fully opened.
All menus and code were fully exposed by that means.
So he then wrote some VBA code built into the start up that entirely disabled the ability to bypass with the shift key.
Now what that code was, I do not know, but I would imagine whatever it was, MAY also be applicable to your F12 key question.
