Solved

Access 2010 - How to hide ribbon

Posted on 2013-06-05
9
842 Views
Last Modified: 2013-06-05
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?
0
Comment
Question by:jbotts
  • 6
  • 3
9 Comments
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
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
 

Author Comment

by:jbotts
Comment Utility
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
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
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
 

Author Comment

by:jbotts
Comment Utility
After review of the post, I guess the File Tab remains, but is useless, and cannot be hidden?
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
Comment Utility
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
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
0
 

Author Closing Comment

by:jbotts
Comment Utility
Thanks so much.
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
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
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
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

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now