Access 2010 - How to hide ribbon

New to Access 2010

I am trying to hide all of the ribbon in a MS Access 2010 application. I have modified the XML code for the ribbon and am able to hide all the buttons and tabs of the File menu, however, I am not able to hide the File menu tab at the top. I have searched the internet and find a recommendation for the following command:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

Where does the above code go? Will it hide the File tab, which as I have currently configured the ribbon, has no functionality?
jbottsAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:
Again, my gut feeling is ... There  must be a way. But so far, seems like no one has figured th is out ... that I can see.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
I pretty sure, but not 100.1% sure - that you cannot remove the File table - if you are in the ACCDB format (you can if in MDB format). However, I keep thinking ... "There MUST be a way"

mx
0
 
jbottsAuthor Commented:
I tried using:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

in the Open event of the first form that displays, but this did not have any effect. I have also used the following in the XML Ribbon table and it did not work:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
      <ribbon startFromScratch="false">
      </ribbon>

<backstage>
    <buttonidMso="FileSave"visible="false"/>
    <buttonidMso="SaveObjectAs"visible="false"/>
    <buttonidMso="FileSaveAsCurrentFileFormat"visible="false"/>
    <buttonidMso="FileOpen"visible="false"/>
    <button idMso="FileCloseDatabase"visible="false"/>
    <tab idMso ="TabInfo"visible="false"/>  
    <tab idMso ="TabRecent"visible="false"/>
    <tabidMso ="TabNew"visible="false"/>
    <tabidMso ="TabPrint"visible="false"/>
    <tabidMso ="TabShare"visible="false"/>
    <tabidMso ="TabHelp"visible="false"/>
    <buttonidMso="ApplicationOptionsDialog"visible="false"/>
    <button idMso="FileExit"visible="false"/>
   </backstage>
 
 </customUI>  

Best option so far is:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
      <ribbon startFromScratch="true">
      </ribbon>
<backstage>
      <button idMso = "ApplicationOptionsDialog" visible="false"/>
      <button idMso = "FileExit" visible="false"/>
      <tab idMso = "TabPrint" visible="false"/>
</backstage>
</customUI>

The above code will make all buttons and tabs in the File Menu (Backstage) not visible, but the File tab remains as does the Quick Access Toolbar.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Yes ...

How to render the Ribbon File Tab useless:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27231448.html

See my posts toward the bottom of the tread ... with XML for USysRibbons table, etc.
0
 
jbottsAuthor Commented:
After review of the post, I guess the File Tab remains, but is useless, and cannot be hidden?
0
 
jbottsAuthor Commented:
Thanks so much.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Seems every post I find shows how to disable items on .. the File tab, but not get rid of it.

Also ... get info on the de-facto standard ribbon tool site:

http://www.ribboncreator2010.de/

and here also:

http://www.ribbon01.com/
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You might actually want to leave this Q open for a while, although this Q comes up frequently.

I'm working with Ribbons a LOT more now, and I will be searching for a way to do this :-)
0
All Courses

From novice to tech pro — start learning today.