Access 2013 ribbon

JohnPapa

Registered User.
Local time
Today, 09:34
Joined
Aug 15, 2010
Messages
1,117
I use the following xml to create a ribbon for Sort and Filter

Code:
<customUI xmlns="[URL]http://schemas.microsoft.com/office/2006/01/customui[/URL]">
     <ribbon startFromScratch="true">
         <tabs>
             <tab idMso="TabCreate" visible="false" />
             <tab id="dbSearchtab" label="Sort and Filter" visible="true">
                 <group id="SearchScreenSort" label="Sort and Filter">
                     <box id="myBox1_h" boxStyle="horizontal">
                         <toggleButton idMso="SortUp" size="large" />
                         <toggleButton idMso="SortDown" size="large" />
                         <button idMso="SortRemoveAllSorts" size="large" />                  
                         <button idMso="FilterBySelection" size="large" />
                         <button idMso="FilterClearAllFilters" size="large" />
                     </box>
                 </group>
             </tab>
         </tabs>
     </ribbon>
 </customUI>

The first problem is that this ribbon appears in forms where it is not included.

The second problem is that in addition to the "File and Filter" tab, there appears a "File" tab Whe you click on it is goes backstage allowing you to Print and Exit.

Any ideas?

Thanks,
John
 
In VBA add the line to HIDE the Office Button and Ribbon ...

DoCmd.ShowToolbar "Ribbon", acToolbarNo

Use ...

DoCmd.ShowToolbar "Ribbon", acToolbarYes

to turn them back on.
 
Dlovan-IT thanks for your reply,

If I include the docmd.ShowToolbar command in the On Open of the form, I can control the presence of the ribbon.
1) Do I have to include the docmd.ShowToolbar command in every form?
2) Still the "File" tab was not removed

Have a look at attachment Ribbon.jpg to see the ribbon and RibbonFile.jpg to see the contents of the tab "File".

Thanks,
John
 

Attachments

  • Ribbon.jpg
    Ribbon.jpg
    64.5 KB · Views: 178
  • RibbonFile.jpg
    RibbonFile.jpg
    34.6 KB · Views: 175

Users who are viewing this thread

Back
Top Bottom