Custom Metro-style Ribbon Switchboard for Access 2007/2010/2013 Updated

There are now three source code ACCDBs with two bonus metro-style databases including one coded for custom ribbon images.

Each database features a space-saving application navigation paradigm that utilizes the flexible Ribbon Bar GUI and tabbed MDI option in Access 2007/2010/2013.

 

 

Features:

• Fully customisable set of context-sensitive Custom Ribbons
• Access 2007/2010/2013 Database Window, Navigation Pane, and Menus fully hidden
• MDI interface with popup dialogs for Add Only forms
• Illustrated instructions and resource links
• Two bonus Metro-style ACCDBs including one coded for custom ribbon images 
• All custom images included

Download the Demos (accrbswb.zip - 451kb)

Visit aadconsulting.com to buy the three full source code ACCDBs now for only $US49.95.
 

New Update of BETA 3 of Ezy Access RibbonX Builder & Editor for MS Access

An updated BETA 3 version of my Access Ribbon Builder and Editor for Microsoft© Access is now available for free download. The Builder is a fast and easy way to build and manage Access Custom Ribbons.  Download

Try the free Access Instant Ribbon Wizard

The Wizard will automatically create an Access 2007/2010/2013 Ribbon Switchboard  based on the native Switchboard Items table in your database built using the native Access Switchboard Manager. Just two clicks and your done.

Free Download

Latest Update of BETA 3 of Ezy Access RibbonX Builder & Editor for Access 2007/2010/2013

An updated BETA 3 version of my Access Ribbon Builder and Editor for Microsoft© Access is now available for free download. The Builder is a fast and easy way to build and manage Access Custom Ribbons.

The update dated 18-Aug-14 supports Access 2007/2010/2013, has a redesigned GUI, and includes bug fixes. All button commands (except the Edit Control button) are now grouped on the LHS of the screen and the msoImage LookUp panel has been moved to the edit control tab. The selected control information box has been made larger to accommodate the data on the more complex controls. Multiple ribbon tabs are now fully supported.

You will need to UNINSTALL previous versions/updates before installing this update.

Download the fully functional unlimited BETA

Ezy Access RibbonX Builder is a basic yet sophisticated tool for building custom ribbonbars using XML files. The most common controls can be edited, and the essential attributes for custom controls can be edited. Native Office 2007 msoImages can be assigned to custom controls.

The ribbon being built is displayed as the active RibbonBar.  You use the treeview representation of the ribbon to navigate and  build the ribbon by adding, editing, copying, pasting, and deleting controls.

File commands:

• Load XML File... Loads an existing XML ribbon file.  The full file path is displayed in the XML File textbox.
• Refresh Reloads the current XML file and refreshes the displayed ribbon.
• Save As...  Saves the current XML file for the displayed ribbon as another file.

Ribbon commands:

• Edit Control Displays an Edit Control tab where you can edit the attributes of the control selected in the treeview.
• New Ribbon... Load a new ribbon stub and creates a new XML file for the ribbon.
• Reference Database... Assigns a database file to populate the onAction combobox for that ribbon control with a macro action from a macro named 'Ribbon'. The full file path is displayed in the Ref DB textbox.
• Templates... Select a ribbon template from the samples shipped with the Builder.

Other functions:

• Control objects combobox Select a control from this combobox to add to the displayed ribbon. Clicking the + button adds the selected control: if the + button is disabled then the selected control cannot be added to the current parent (container) control.  The buttons to the right of the + button from left-to-right delete, copy, or paste the control currently selected in the treeview.  The name of a copied control that has not yet been pasted is displayed in a label between the Paste and the Edit Control buttons.
• Lookup Office Image panel The functions in this panel allow you to assign images to custom ribbon controls during editing.  Place your mouse over a control in this panel for details of the function performed

Download the fully functional unlimited BETA

Updated BETA 3 of Ezy Access RibbonX Builder & Editor for Access 2007/2010/2013

An updated BETA 3 version of my Access Ribbon Builder and Editor for Microsoft© Access is now available for free download. The Builder is a fast and easy way to build and manage Access Custom Ribbons.  The update dated 4-Aug-14 supports Access 2013 and includes bug fixes.

You will need to UNINSTALL previous versions/updates before installing this update.

Download the fully functional unlimited BETA

Ezy Access RibbonX Builder is a basic yet sophisticated tool for building custom ribbonbars using XML files. The most common controls can be edited, and the essential attributes for custom controls can be edited. Native Office 2007 msoImages can be assigned to custom controls.

The ribbon being built is displayed as the active RibbonBar.  You use the treeview representation of the ribbon to navigate and  build the ribbon by adding, editing, copying, pasting, and deleting controls.

File commands:

• Load XML File... Loads an existing XML ribbon file.  The full file path is displayed in the XML File textbox.
• Refresh Reloads the current XML file and refreshes the displayed ribbon.
• Save As...  Saves the current XML file for the displayed ribbon as another file.

Ribbon commands:

• Edit Control Displays an Edit Control tab where you can edit the attributes of the control selected in the treeview.
• New Ribbon... Load a new ribbon stub and creates a new XML file for the ribbon.
• Reference Database... Assigns a database file to populate the onAction combobox for that ribbon control with a macro action from a macro named 'Ribbon'. The full file path is displayed in the Ref DB textbox.
• Ribbon Wizard... Select a ribbon template from the samples shipped with the Builder.

Other functions:

• Control objects combobox Select a control from this combobox to add to the displayed ribbon. Clicking the + button adds the selected control: if the + button is disabled then the selected control cannot be added to the current parent (container) control.  The buttons to the right of the + button from left-to-right delete, copy, or paste the control currently selected in the treeview.  The name of a copied control that has not yet been pasted is displayed in a label between the Paste and the Edit Control buttons.
• Lookup Office Image panel The functions in this panel allow you to assign images to custom ribbon controls during editing.  Place your mouse over a control in this panel for details of the function performed

Download the fully functional unlimited BETA

How to Hack the Access 2010 & Access 2013 Customized Application Ribbon to Build Custom Ribbons Using Ezy Access Ribbon Builder

Click on the image to zoom

Starting with Access 2010, you can customize the Application Ribbon by right-clicking in the Ribbon-bar and selecting  Customize the Ribbon from the popup menu. You can use macro actions to fire custom commands on the Ribbon, using custom tabs, groups, and buttons. You can assign some very basic icons to custom commands and edit the labels, and you can hide Access development environment tabs, groups, and commands

The limitation is that the customization applies to the Access application and is not stored in the database. You can export the customization to an XML file with the extension .exportedUI. You can then import the file to use that customization in any instance of the Access application.

Custom database specific Ribbons must be built outside Access and loaded at run-time using VBA or the USysRibbon paradigm. For more information on how these custom ribbons are built look at this Access Extra post How to Build an Access 2007 Ribbon.

I have a ribbon builder tool for Access 2007/2010/2103 which is currently in BETA - Ezy Access RibbonX Builder. Details and the free download are here. With this tool you can build custom ribbons from scratch.

I have come up with a way to make the task of building custom Access ribbon easier, and here I will explain how to build a ribbon like the one in the screenshot at the top of this post.

1. I have a database where all the actions I want to include in my custom ribbon are saved as macros. The ribbon I want to build will also comprise some standard Access menu commands.

2. In Access with my database open, I invoke the Access Options dialog and click on Customize Ribbon in the sidebar, and customise the application ribbon as shown below:

Click on the image to zoom

This customization results in this application ribbon:

Click on the image to zoom

To save this customization in an XML file, I click Import/Export and select Export all customizations, and Access will save the customization with the extension .exportedUI.  You can now click Reset to remove the customization to the application ribbon.

3.  I need to do a few things to the XML file before I can use it in Ezy Access Ribbon Builder:

• Rename the file with the extension .XML.
• Edit the XML file to remove redundant text that is not recognised as well-formed XML by Access when you load a user-generated custom ribbon.

I use the free version of Expression Web 4 (download here) to prepare the XML file.

4. I open my XML file in Expression Web 4:

Click on the image to zoom

I then proceed as follows:

• Right-click in the document and click Reformat XML  to format the XML correctly
• Select and delete the first three lines of the reformatted document:

• Right-click in the document and click Verify well-formed XML...  to check that all the XML parses without error.

5. I save the XML file and exit Expression Web 4.

6. I open the XML file in Ezy Access RibbonX Builder to finesse the custom ribbon by using some different menu elements and the full range of native Office icons.

Update 25 June 2013: XML Notepad 2007 can also be used to work with the XML file.

Click on the image to zoom

7. After working on the XML in the Builder, I have a custom ribbon for my database:

Click on the image to zoom

NEW BETA 3 of Ezy Access RibbonX Builder & Editor for Access 2007/2010/2013

A new BETA 3 version of my Access Ribbon Builder and Editor for Microsoft© Access is now available for free download.  There is a new GUI, additional features, some bug fixes, and the app now supports Access 2007/2010/2013. The Builder is a fast and easy way to build and manage Access Custom Ribbons.

Download the fully functional unlimited BETA

Ezy Access RibbonX Builder is a basic yet sophisticated tool for building custom ribbonbars using XML files. The most common controls can be edited, and the essential attributes for custom controls can be edited. Native Office 2007 msoImages can be assigned to custom controls.

The ribbon being built is displayed as the active RibbonBar.  You use the treeview representation of the ribbon to navigate and  build the ribbon by adding, editing, copying, pasting, and deleting controls.

File commands:

• Load XML File... Loads an existing XML ribbon file.  The full file path is displayed in the XML File textbox.
• Refresh Reloads the current XML file and refreshes the displayed ribbon.
• Save As...  Saves the current XML file for the displayed ribbon as another file.

Ribbon commands:

• Edit Control Displays an Edit Control tab where you can edit the attributes of the control selected in the treeview.
• New Ribbon... Load a new ribbon stub and creates a new XML file for the ribbon.
• Reference Database... Assigns a database file to populate the onAction combobox for that ribbon control with a macro action from a macro named 'Ribbon'. The full file path is displayed in the Ref DB textbox.
• Ribbon Wizard... Select a ribbon template from the samples shipped with the Builder.

Other functions:

• Control objects combobox Select a control from this combobox to add to the displayed ribbon. Clicking the + button adds the selected control: if the + button is disabled then the selected control cannot be added to the current parent (container) control.  The buttons to the right of the + button from left-to-right delete, copy, or paste the control currently selected in the treeview.  The name of a copied control that has not yet been pasted is displayed in a label between the Paste and the Edit Control buttons.
• Lookup Office Image panel The functions in this panel allow you to assign images to custom ribbon controls during editing.  Place your mouse over a control in this panel for details of the function performed

Download the fully functional unlimited BETA

Access 2010: Download the Interactive Menu to Ribbon Guide

A visual, interactive reference guide to help you find the new location of commands in Access 2010. Download

New Office Ribbon Developer Center Launches on MSDN

A new Office Fluent UI Developer Center has been launched on MSDN, where you can dind developer resources for customizing the Backstage view for Office 2010 and the Ribbon UI for Office 2010 and Office 2007.

Access 2010 Disappointment #1: Limited Ribbon Customisation

The much-hyped customisation feature for RibbonBars in Access/Office 2010 is very limited. It allows the user to only add custom tabs to native Ribbons.  You cannot create custom Ribbons in the GUI.

Office 2010 Implements User-Interface Ribbon Customization

Office 2010 will support what should have been in Office 2007: user-customization of RibbonBars across all Office client applications, using a paradigm similar to the right-click Customize... command available on CommandBars in pre-Office 2007 versions.  More at the Microsoft Office 2010 Engineering blog.

How to Build an Access 2007 Ribbon

Access MVP Garry Robinson has posted a useful article on building custom Access 2007 ribbons using the tool IDBE Ribbon Creator tool from http://www.ribboncreator.de/en/.

You should also checkout an article I wrote in December How Custom Access 2007 Ribbons Work.

I will take this opportunity to promote two free tools I have developed for reviewing custom ribbons that you can download from aadconsulting.com:

• Office 2007 Ribbon XML File Reviewer
• Access 2007 USysRibbons Reviewer Add-In
  

These tools providing advanced Office 2007 RibbonX review features. Open any Office 2007 Ribbon XML file in the XML File Reviewer to review an Office Ribbon's full menu hierarchy in a tree-view with all control attributes detailed in an adjacent panel.

The Access 2007 USysRibbons Add-In reviews and previews the custom Ribbons in the USysRibbons table of an Access 2007 database. Extensive reference resources are incorporated into the GUI of both products. Both tools require Access 2007.

The Access Ribbon Review in action (click on the image to enlarge):

Office 2007 Ribbon XML File Reviewer Freeware

Click on the image to zoom in...

My new Access freeware tool provides advanced Office 2007 Ribbon XML file review features. Open your Ribbon XML file in the Reviewer to review the Ribbon's full menu hierarchy in a tree-view with all control attributes detailed in an adjacent panel. Extensive reference resources are also incorporated into the GUI.

Download (Requires Access 2007)

You can also try the free BETA 2 of Access 2007 RibbonX Reviewer and Builder Add-In

BETA 2 of Custom RibbonX Reviewer for Access 2007

Click on the image to zoom in...

Download the just released free BETA 2 of my Access 2007 RibbonX Reviewer and Builder Add-In

BETA 2 provides advanced Access 2007 RibbonX review and build features, and is now deployed as an Access 2007 Add-In. You can create new Ribbons, copy/paste controls, and add new controls and delete controls on-the-fly. Extensive reference resources are incorporated into the GUI.

The next update will add the editing of control attributes.

Installation is now via a SetUp.exe file which includes the required DLL's and OCX's. The XML Preview Pane requires IE v 6.x or later. Make sure you read the readme.txt file.

NEW: Access 2003 to Access 2007 Interactive Command Reference Guide

Download a visual interactive reference guide to help you find Access 2003 commands in the new Access 2007 Ribbonbars.

You can also download the Access Ribbon mapping workbook, an Excel file that lists the commands on each tab of the Access 2007 Ribbon and the menu/toolbar location in previous versions of Access. Instructions on the first tab of the workbook provide tips for customizing, finding, and printing data.

Access 2007 Pain: RibbonBar

I was never a fan of the RibbonBar gui in Office 2007, but was ready to accept the need to work with it.

But at each step in the learning process , there is nothing but frustration. And I am not alone: read the comments to a post on the Access Team Blog.

A partial random list of annoyances:

1. There is no way to build or even review RibbonBars natively in Access 2007.
   
   
2. The XML for a RibbonBar does not parse in MS XML Notepad or by using the MSXML dlls - the XML needs to be modified to be read.
   
   
3. Using more than one period (.) in a row in a label breaks the XML.
   
   
4. There is no easy way to get the ImageID of a native image: you have to download an obscurely located Excel file.
   
   
5. The MS Custom Office UI Editor returns malformed XML errors by referring to the line and character number, but - you guessed it - the Editor screen has neither.
   
   
6. There is next to nothing on customizing the RibbonBar in the Access Help file. The only articles where you can get any coherent information have been written by third parties.
   
   
7. If you want to preview a native RibbonBar image in an Access form, you can't use the Access image control - you have to use the MS Forms image control, which is not fully supported in Access.

In one of the comments to the above-mentioned post, well-known Access writer Mike Groh, said:

"Without intellisense and without an Object Browser view of the ribbon hierarchy, it's very, very difficult to make headway on ribbon customization."

A correction: The RibbonBar gui does not have an object model, so the hierarchy has to be viewed in some other way.

On 20 Sep I posted my Custom RibbonX Reviewer BETA, for free download. The Reviewer loads a custom RibbonBar into a treeview to show the full hierarchy, and all attributes and values for each item, as well as displaying the actual RibbonBar. There are also extensive reference resources incorporated into the GUI. The next stage in the project is to deploy the app as an add-in that will work inside the users' ACCDB, and provide in-place editing of RibbonBars using a pseudo-object model.

I sent an email to the Access Team Blog on this app, in the hope I would get some support or feedback. The email has been ignored.

Custom RibbonX Reviewer for Access 2007


Click on the image to zoom in...

I am making available a free BETA of my Access 2007 RibbonX Reviewer for download. Make sure you read the readme file.

This is very much a stage 1 app, with the aim being in the next stage to deploy it as an add-in that will work inside the users' ACCDB, and eventually to provide in-place editing of Ribbonbars. I put the BETA out now, so that any bugs can identified before I go too far into the next stage.

Open the file RibbonXReview.accde in Access 2007 to review sample Access 2000 RibbonBars using the USysRibbons table.

Theres are also extensive reference resources incorporated into the GUI.

You can load your own USysRibbons table by importing it into the ACCDE and replacing the sample USysRibbons table.