Link to home
Create AccountLog in
Avatar of abcctech
abcctechFlag for United States of America

asked on

Microsoft Access 2010: How to Hide File tab and also Hide Min Ribbon Bar, Access Help, Min, Restore, Close on the right/top of screen

Help!  I’m new to Access 2010 and trying to create Ribbon Bars…
I can’t seem to “hide” the File portion of the Ribbon bar.  When I create the ribbon bar and put it on a form I still see the File tab and Save, Save Object As, Save Db As, Open, Close db, List of recent db’s opened, Info, Recent, New, Print, Save & Publish, Help, Options, Exit
On my Main Menu form I Hide the Navigation Pane on the Open Method:
  DoCmd.SelectObject acTable, "ProjectInfo", True
 If Application.CurrentObjectName = "ProjectInfo" Then DoCmd.RunCommand acCmdWindowHide

 I’ve created a table called: USysRibbons
  -contains the ribbon bars I created
 On the forms I put in the Ribbon Name from the USysRibbons table  
 
Here is an example of my ribbon bar:

  <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
  <ribbon startFromScratch="true">
 <qat>
     <sharedControls>
     </sharedControls>    
       <documentControls>                    
       </documentControls>
     </qat>
    <tabs>  
      <tab id="dbCustomTabFile" label="File" visible="true">
         <group id="dbCustomGroupFile" label="File Group">                  
            <control idMso="MasterViewClose" label="Close Screen" enabled="true"/>              
         </group>
     </tab>
        <tab id="dbCustomTabEdit" label="Edit" visible="true">
          <group id="dbCustomGroupEdit" label="Edit Group">                  
            <control idMso="Undo" label="Undo" enabled="true"/>
            <control idMso="Cut" label="Cut" enabled="true"/>
            <control idMso="Copy" label="Copy" enabled="true"/>
            <control idMso="Paste" label="Paste" enabled="true"/>        
          </group>
      </tab>
         <tab id="dbCustomTabPrint" label="Print" visible="true">      
         <group id="dbCustomGroupPrint" label="Print Group">                  
             <control idMso="FilePrintQuick" label="Quick Print" enabled="true"/>
             <control idMso="FilePrintMenu" label="FilePrintMenu" enabled="true"/>  
             <control idMso="PrintPreviewClose" label="Close Print Preview" enabled="true"/>              
        </group>
  </tab>
      <tab id="dbCustomTabHelp" label="Help" visible="true">      
         <group id="dbCustomGroupHelp" label="Help Group">  
            <control idMso="SpellingAccess" label="Spelling" enabled="true"/>    
            <button id = "OpenForm" imageMso ="Help" label = "Data Entry Help" onAction = "OnButtonPress"  tag="Help"/>              
            <control idMso="ViewsDesignView" label="ABCC Only (D)" enabled="true"/>
            <control idMso="ViewsLayoutView" label="ABCC Only (L)" enabled="true"/>
      </group>
      </tab>
    </tabs>
  </ribbon>
 <backstage>
     <button idMso="FileCloseDatabase" visible="false"/>
     <button idMso="SaveObjectAs" visible="false"/>
     <button idMso="FileSaveAsCurrentFileFormat" visible="false"/>
     <button idMso="FileOpen" visible="false"/>
     <button idMso="FileSave" visible="false"/>
     <tab idMso="TabInfo" visible="false"/>
     <tab idMso="TabRecent" visible="false"/>
     <tab idMso="TabNew" visible="false"/>
     <tab idMso="TabPrint" visible="true"/>
     <tab idMso="TabShare" visible="false"/>
     <tab idMso="TabHelp" visible="false"/>
     <button idMso="ApplicationOptionsDialog" visible="false"/>
     <button idMso="FileExit" visible="false"/>    
  </backstage>
</customUI>


I thought the <backstage> portion would ‘hide’ the File tab…  But it’s still there.

Also how do you hide the functions on the right side of the screen (Min Ribbon Bar, Access Help, Min, Restore, Close)

Thanks in advance for any suggestions

Thanks,
   Donna
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Avatar of abcctech

ASKER

Hi mx,
I agree with you we absolutely need to find a way to hide that "FIND" tab...
When I put in  DoCmd.ShowToolBar "ribbon", acToolBarNo.  I no longer see my customized ribbon...
I need to have that ribbon on the screen...

Why doesn't the <backstage> thing work?  Does anyone know?

This is insane....  I have 22 db's that have to be converted to Access 2010!


what FInd tab? can you show a pic of it?
try this
access options>>current database>> document window options
select document "tabbed Documents"
uncheck "display Document tabs"
ee2.bmp
Sorry I meant File Tab..
See the  2 File tabs below...  The First one is the one that has to be hidden and I can't find how to hide it.

File1.png
here try the below code.
* note that all of the things you can make not visible are done with <ribbon startFromScratch="true">  * with the exception of the help button.
so your "backstage" section is unnecessary.

i am using 07 so i cant test the below code  i changed the schema/ the first line. change it back to
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">

'---------------code

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">

  <commands>
  <command idMso="Help"  enabled="false"/>
  </commands>
<ribbon startFromScratch="true">
<tabs>  
      <tab id="dbCustomTabFile" label="File" visible="true">
         <group id="dbCustomGroupFile" label="File Group">                  
            <control idMso="MasterViewClose" label="Close Screen" enabled="true"/>              
         </group>
     </tab>
        <tab id="dbCustomTabEdit" label="Edit" visible="true">
          <group id="dbCustomGroupEdit" label="Edit Group">                  
            <control idMso="Undo" label="Undo" enabled="true"/>
            <control idMso="Cut" label="Cut" enabled="true"/>
            <control idMso="Copy" label="Copy" enabled="true"/>
            <control idMso="Paste" label="Paste" enabled="true"/>        
          </group>
      </tab>
         <tab id="dbCustomTabPrint" label="Print" visible="true">      
         <group id="dbCustomGroupPrint" label="Print Group">                  
             <control idMso="FilePrintQuick" label="Quick Print" enabled="true"/>
             <control idMso="FilePrintMenu" label="FilePrintMenu" enabled="true"/>  
             <control idMso="PrintPreviewClose" label="Close Print Preview" enabled="true"/>              
        </group>
  </tab>
      <tab id="dbCustomTabHelp" label="Help" visible="true">      
         <group id="dbCustomGroupHelp" label="Help Group">  
            <control idMso="SpellingAccess" label="Spelling" enabled="true"/>    
            <button id = "OpenForm" imageMso ="Help" label = "Data Entry Help" onAction = "OnButtonPress"  tag="Help"/>              
            <control idMso="ViewsDesignView" label="ABCC Only (D)" enabled="true"/>
            <control idMso="ViewsLayoutView" label="ABCC Only (L)" enabled="true"/>
      </group>
      </tab>
    </tabs>


</ribbon>
</customUI>
***
i am using 07 so i cant test the below code  i changed the schema/ the first line. change it back to
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">

change it back if you recieve an error**

here is a good link to check out on ribbons that i came accross

http://msdn.microsoft.com/en-us/library/dd909370(v=office.12).aspx
this looks like the link where the answer would be if there is one

http://msdn.microsoft.com/en-us/office/aa905530.aspx
Hi Conagraman,
 I tried your code and still see the whole microsoft File tab (as is was before).  I was so hoping this would work.  Does it work in Access 07?  Do you think they totally changed it in Access 2010?  Is that why it's not working??
 I'm checking out those 2 links you sent.  So far, I haven't see anything that would help but I'll keep looking in there.
 The "Backstage" stuff I see all over (like in my original code) just doesn't work...
just to be sure: you do know your asking for a file tab?

<tab id="dbCustomTabFile" label="File" visible="true">
         <group id="dbCustomGroupFile" label="File Group">                  
            <control idMso="MasterViewClose" label="Close Screen" enabled="true"/>              
         </group>
     </tab>
i cant help you with the backstage stuff. its only in 2010. here is a link for it

http://msdn.microsoft.com/en-us/office/ff808348.aspx
i dont see the file tab. if the code dosent help i'd wonder if you can get rid of it.

in 07 i cant get rid of the "microsoft button" i wonder if they changed it to the "file" button.
ya thats exactly what it looks like. they replaced the "office" button with a file tab. i have tried everything to hide that. ur prob sol.
What is in the Microsoft Button?   Does it have:  Save, Save Object As, Save Db As, Open, Close db, List of recent db’s opened, Info, Recent, New, Print, Save & Publish, Help, Options, Exit?  That is what is in the File Tab now...
The Code: <tab id="dbCustomTabFile" label="File" visible="true">   is to show "My" version of the file tab I want my users to see.
The Backstage stuff (from what I am reading..) is to manipulate the "File Tab" stuff.
<backstage>
     <button idMso="FileCloseDatabase" visible="false"/>
     <button idMso="SaveObjectAs" visible="false"/>
I'm trying to make them "Not visible"...  Well at least I'm trying and it's not working...
How do you work around the Microsoft Button?  


see my last post. there is no work around.
what i can do is hide almost all of the options that appear. sounds like the same thing as the backstage. so there is almost nothing on the menu except a close button
Yes, that is what I am trying to do with the backstage thing...  But it's just not working.  
Do you have the code that hides all but the close button?  

This shouldn't be that hard should it?  Why do they do this to us?  You would think that would be an option because that file tab is so powerful and the user can ruin your database that you just wrote!
There should be an option to just turn it off!

try this command

docmd.showtoolbar "ribbon",actoolbarno
Hi Capricon1,
 if I use: DoCmd.ShowToolbar "Ribbon", acToolbarNo then I don't see the File tab (which is what I want) but I do not see my customized ribbons either.
This is driving me insane...  
ok
place this code in between  <ribbon startFromScratch="true"> and <tabs>
 in your xml so for example <ribbon startFromScratch="true"> the below code goes here----<tabs>

 <officeMenu>
   
   <control idMso="FileNewDatabase" visible="false"/>
   <control idMso="SourceControlCreateDatabaseFromProject" visible="false"/>
   <control idMso="FileOpenDatabase" visible="false"/>
   <control idMso="FileSave" visible="false"/>
   <control idMso="ConvertDatabaseFormat" visible="false"/>
   <control idMso="FileSaveAsMenuAccess" visible="false"/>
   <control idMso="FileManageMenu" visible="false"/>
   <control idMso="FileSendAsAttachment" visible="false"/>
   <control idMso="MenuPublish" visible="false"/>
   <control idMso="FileServerMenu" visible="false"/>
   <control idMso="FileCloseDatabase" visible="false"/>                                                        

  </officeMenu>
i dont have 2010 so you will have to work off of what i have here and hope there is something like it.

in 2007 i would uncheck the "allow full menus" in my ribbon options. see the below pic. again this is 07 non 2010 so it might look a bit different.


eerib.bmp
thats it.
Hi Conagraman,
  Access 2010 options looks just like that.  I already had "Allow Full Menus" unchecked...
 Still see the File tab. User generated image
you will see the file tab no matter what you try. what i am saying is you can hide all the options it would bring up.
this means i went from the normal menu to just recent documents and a close button. its not ideal but the best i think you can get.
eemenu.bmp
Yes, I understand that now...  I will still see "File" but nothing should be in there.  Right?  Unfortunately, I still see the file tab and all of it's contents...
 with this code:
 <backstage>
     <button idMso="FileCloseDatabase" visible="false"/>
     <button idMso="SaveObjectAs" visible="false"/>
     <button idMso="FileSaveAsCurrentFileFormat" visible="false"/>
     <button idMso="FileOpen" visible="false"/>
      .......
Oh I wish I could just do what you have up there!!!
   That has to be doable in 2010!   Doesn't anyone else use 2010 out there?
you could try

<backstage>
   
   <button idMso="FileNewDatabase" visible="false"/>
   <button idMso="SourceControlCreateDatabaseFromProject" visible="false"/>
   <button idMso="FileOpenDatabase" visible="false"/>
   <button idMso="FileSave" visible="false"/>
   <button idMso="ConvertDatabaseFormat" visible="false"/>
   <button idMso="FileSaveAsMenuAccess" visible="false"/>
   <button idMso="FileManageMenu" visible="false"/>
   <button idMso="FileSendAsAttachment" visible="false"/>
   <button idMso="MenuPublish" visible="false"/>
   <button idMso="FileServerMenu" visible="false"/>
   <button idMso="FileCloseDatabase" visible="false"/>                                                        

  </backstage>
or maybe

<backstage>
   
   <control idMso="FileNewDatabase" visible="false"/>
   <control idMso="SourceControlCreateDatabaseFromProject" visible="false"/>
   <control idMso="FileOpenDatabase" visible="false"/>
   <control idMso="FileSave" visible="false"/>
   <control idMso="ConvertDatabaseFormat" visible="false"/>
   <control idMso="FileSaveAsMenuAccess" visible="false"/>
   <control idMso="FileManageMenu" visible="false"/>
   <control idMso="FileSendAsAttachment" visible="false"/>
   <control idMso="MenuPublish" visible="false"/>
   <control idMso="FileServerMenu" visible="false"/>
   <control idMso="FileCloseDatabase" visible="false"/>                                                        

  </backstage>
I tried that.  Got errors on these lines:  SourceControl CreateDatabaseFromProject, ConvertDatabaseFormat, MenuPublish..  I think those names have changed in 2010.
get rid of thoes two lines. are the others gone?
which one are you using   <control idMso or <button idMso?
when i get rid of the code i only have a few options new open and close database. so maybe some of that code is not needed anyway.

try just using

   FileNewDatabase" FileOpenDatabase" FileCloseDatabase"                                                        

worked on my end
Tried:
   <control idMso="FileNewDatabase" visible="false"/>  
   <control idMso="FileOpenDatabase" visible="false"/>  
   <control idMso="FileCloseDatabase" visible="false"/>      
 I think is doesn't like Control idMso.  I get an error on each of these lines...
  No error on  <button idMso="FileCloseDatabase" visible="false"/>
so this?
<backstage>
   
   <button idMso="FileNewDatabase" visible="false"/>
   <button idMso="FileOpenDatabase" visible="false"/>
   <button idMso="FileCloseDatabase" visible="false"/>                                                        

  </backstage>
The only backstage command I have in there is : <button idMso="FileCloseDatabase" visible="false"/>

When I click on the File tab I still see "Close Database."  along with all of the other stuff.

Here it is:
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
  <ribbon startFromScratch="true">
    <tabs>  
     <tab id="MyTab1" label="My Tab 1">
      </tab>
    </tabs>
  </ribbon>
 <backstage>
     <button idMso="FileCloseDatabase" visible="false"/>  
  </backstage>
</customUI>
looks like you might have already had it. i just didnt realize you did.

<backstage>
<button idMso="FileSave" visible="false"/>
        <button idMso="FileSaveAs" visible="false"/>
        <button idMso="FileOpen" visible="false"/>
        <button idMso="FileClose" visible="false"/>
        <button idMso="ApplicationOptionsDialog" visible="false"/>
        <button idMso="FileExit" visible="false"/>
        <tab idMso="TabInfo" visible="false"/>
        <tab idMso="TabRecent" visible="false"/>
        <tab idMso="TabNew" visible="false"/>
        <tab idMso="TabPrint" visible="false"/>
        <tab idMso="TabShare" visible="false"/>
        <tab idMso="TabHelp" visible="false"/>
</backstage>
ASKER CERTIFIED SOLUTION
Avatar of abcctech
abcctech
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
yes that does make sense. a custom xml ribbon in my environment doesn’t appear until runtime. glad you figured it out! also thanks for posting what you found out as i am sure i will be switching to 2010 soon.

: )
"Donna'
fyi only ... your EE icon shows a male :-)

So, in summary ... which post Hides the File tab ... while retaining any custom menus from A2003 on the Add-In ribbon ...?

mx
in summary the only way to hide the file tab is to hide the entire ribbon.
Hi DatabaseMX,
  This is what hides the file tab:
 <backstage>
<button idMso="FileSave" visible="false"/>
        <button idMso="FileSaveAs" visible="false"/>
        <button idMso="FileOpen" visible="false"/>
        <button idMso="FileClose" visible="false"/>
        <button idMso="ApplicationOptionsDialog" visible="false"/>
        <button idMso="FileExit" visible="false"/>
        <tab idMso="TabInfo" visible="false"/>
        <tab idMso="TabRecent" visible="false"/>
        <tab idMso="TabNew" visible="false"/>
        <tab idMso="TabPrint" visible="false"/>
        <tab idMso="TabShare" visible="false"/>
        <tab idMso="TabHelp" visible="false"/>
</backstage>
 also added code to hide the "Recent db"
  see this:
    http://www.accessribbon.de/en/index.php?FAQ:FAQ_Access_2010:2

Thanks for the EE icon tip!
 Donna

conagraman is correct.  
 What the code does is hide what is in the File tab.   But you still see the  "FIle" tab.
   I put a Close Program button on that tab...  So, that is all you see in there!

  Hope that clears things up!
 
  Donna
Would you be able to post a screen shot of the 'ribbon' are (top of app) that shows the end result?

thx.mx
i can’t show you 2010 but see my post 34122170 to see 2007. I’m sure the result is similar.
Here is a picture...
 User generated imagePic2.bmp
So, I'm slightly confused.  The File tab is still there?  And if you click it, does all of the stuff underneath appear ?

And you created the Close and Help items ?

mx
Yes, the file tab is still there..  If you click on it the only thing you see is the "Return to Main Menu" button.  Yes, I  created the Close and Help tabs. They have things that are needed for this specific program.  
The file tab is the system generated one that you can't hide without totally hiding all Ribbon Bars.
So, the solutions is to hide all of the contents in the File tab (hide the Save db, Options, Print, Recent db, etc...)  I put the "Return to Main Menu" button in the File Tab.  So what ever screen they are in at the time they can click on the "FIle" tab and  then click on "Return to Main Menu" button to get back to the Main Menu Screen of the program.
I see. So, I'm wondering if ... I had an A2003 custom menu, that would appear on the Add-In Ribbon ... if I 'hide' the File tab in this context, will I see the File tab + my custom menu (via the Add-In ribbon) ... say in place of your Close & Help items ..?

Also, did you use the     http://www.accessribbon.de/en/  tool to create all of this ?

thx.mx

I'm not sure about that?!!?   Haven't tried that.  
 I converted my Custom Menus/toolbars to the XML code...
" I converted my Custom Menus/toolbars to the XML code..."
Meaning you recreated them in XML ... or used some conversion tool?
The reason I'm asking these questions is I will be doing this shortly on many mdb's here at work.  I just got an A2010 workstation set up yesterday ... to start testing A2003 apps on.  Not converting to ACCDB, but they need to run in the A2010 environment.

mx
btw ... close the Q anytime you like ... no pts for me, these are just academic questions ... lingering on lol.

mx
No, I didn't use a conversion tool.  Found stuff on the internet to help me create the code.
This is a good site to use:
Access Ribbon Website  called Avenius Gunter
<http://www.accessribbon.de/en/index.php?Welcome
We are moving to Office 2010 and I have many db's to convert.  I'm converting to ACCDB.  Why are you staying with the mdb format?  

Not converting at this time because O2010 deployment to all work stations will not be simultaneous ... and not starting until Dec or Jan.  So, the apps will have to work in both environments for a period of time. Down the road next year, I will mostly likely convert ... once everything is 'stable'.

mx
I didn't realize I had to run the program from scratch to see that the  <backstage> code I had worked....