restoring toolbars once removed when customising

D

Dan

Hi,

Is it possible to restore the toolbars within Access once you have removed
them to stop users from accessing the backend?
 
M

Micah Chaney

If you mean just for your use...you can create a Macro with the ShowToolbar
action. I'm sure you can do this in code too, but I don't know code, so I
can't help you with that option. If you press F11 I think, you can display
the Database Window, the main Window ("backend"), then go to your macro
section, and run your ShowToolbar macro, your toolbars should appear. You
can also choose what Toolbars you want to show. OR when you open the
database, hold the shift key while you open it (if there's a password, hold
shift after you type in the password and before you hit OK). this will
bypass any start up settings you may have, including the hiding of any
toolbars.

Hope this helps.
 
A

Albert D. Kallal

What you should do is specify the main menu bar in the tools startup.

You then specify what tool and menu bars you want for each form in the
"other" tab.

That way, if you hold down the shift key during startup, the you get all of
the ms-access interface and menu bars. If you run the application without
holding down the shift key, then the users see none of the ms-access
interface. You don't need code to do this.

Grab the 3rd (ms-access interface hidden) example here, and run it....

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

Then try holding down the shift key. This approach takes no special code,
and you eliminate the problem of hiding/un-hiding the menu bars.
Is it possible to restore the toolbars within Access once you have removed
them to stop users from accessing the backend?
Click to expand...

As mentioned, if you approach this problem correctly, then you don't have to
restore anything.

Further, once you get the hang of the above, then grab my shift key
set-unsetter here:

And, of course you ALWAYS distribute a mde to your users. using the above,
it takes no code, and you lock up the applications quite nicely, and you
don't have to implement security..or use any code to hide/un-hide menu bars
etc.
 
Top