Jess31
asked on
Access 2007?
I am running an Access 2K mdb in Access 2007. In Access 2K under Tools/Startup I shut off the various menus from appearing. Here in Access 2007 a whole bunch of stuff appears on the top. How can I shut them off?
You can't. This is the new ribbon interface.
click on the Customize Quick Access Toolbar down arrow and select Minimize the Ribbon
ASKER
where do I find Customize Quick Access Toolbar?
see the highlighted part of the image
CQAT.JPG
CQAT.JPG
ASKER
capricorn1,
This seems to minimize it for all apps, can I do it (say in code perhaps?) where it is minimized only for a specific app?
This seems to minimize it for all apps, can I do it (say in code perhaps?) where it is minimized only for a specific app?
Hi Jess31,
- Create the following function in module:
Function fHideRibbon()
DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Function
- Create AutoExec macro (if you do not have one),
- Call the above function from AutoExec macro when your application starts (Action - RunCode, Arguments - fHideRibbon()).
DoCmd.ShowToolbar "Ribbon", acToolbarYes
can be used to show ribbon back
Hope this helps
- Create the following function in module:
Function fHideRibbon()
DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Function
- Create AutoExec macro (if you do not have one),
- Call the above function from AutoExec macro when your application starts (Action - RunCode, Arguments - fHideRibbon()).
DoCmd.ShowToolbar "Ribbon", acToolbarYes
can be used to show ribbon back
Hope this helps
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.