Hi EE,
If one uses the UsysRibbons table approach to create a ribbon that shows very little
to essentially hide the ribbon and calls it HideTheRibbon, and then specifies this
ribbon name under File/Options/CurrentDataba
se, then when click on accdb, the ribbon
is hidden
what happens if you want to go back to development mode and use Access default ribbons.
how do you toggle between show/hide ribbon
a) do you press SHIFT key while click on accdb to break into db for development
b) for some reason the show/hide toolbar "ribbon" vba is not working for me
below is an uploaded test mdb. Nick and EE expert helped me with it yesterday.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28140895.html
c) p.s. i learned here how to manually turnoff the tab in the ribbon called Adobe:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/1d79779c-a229-4c50-81dd-0f27f97a828c/
so if you are expecting to see the Adobe tab on your machine, it is missing bec i turned
off the add in.
tx in advance for your help, sandra
Nick-EE.accdb
a) Yes, you are correct - if you hold the Shift key when you open a database, then ALL of the startup options are ignored, including the custom ribbon setting. This feature can be "turned off" by creating a database property named "AllowBypassKey" and setting its value to False.
b) DoCmd.ShowToolbar "Ribbon", acToolbarNo can be used at any time to hide the current ribbon, and DoCmd.ShowToolbar "Ribbon", acToolbarYes will show it again.
However, you should remember that the "current ribbon" changes when you open different objects - for example, if you hide the database ribbon and then open a form then the form ribbon will show. To avoid this you can put code to hide the ribbon in each form's Form_Open event procedure.
Best wishes,
Graham Mandeno [Access MVP 1996-2013]