ms access 2007 - How to Hide Ribbon except when deving -
i using access 2007 , creating invoicing system parent's business. when i'm developing in access, able see ribbon nav, , object nav on over left. when push out them use, hide of junk.
is there easy way enter access db "dev" giving of options, when opened end user, see forms have autoexec'd open when database opened?
to toggle navigation pane, use f11. toggle ribbon, ctrl+f1 --- minimizes ribbon rather hides completely.
if want similar vba code:
'hide navigation pane docmd.selectobject actable, , true docmd.runcommand accmdwindowhide 'unhide navigation pane docmd.selectobject actable, , true 'hide ribbon docmd.showtoolbar "ribbon",actoolbarno 'unhide ribbon docmd.showtoolbar "ribbon",actoolbaryes
an easy way distinguish between development , production versions of application place them in separate folders.
if currentproject.path "*dev*" 'do want development mode else 'do want production mode end if
if doesn't work you, there many alternatives.
a table store status, retrieve status @ startup, , adjustments based on status.
same approach, using database property instead of table.
a module variable code checks determine status.
those few, can come plenty more if you're motivated.
Comments
Post a Comment