You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Despite my passion for all things related to code, I've always had a soft spot for UI that is exciting both in its "coolness" factor and visual appeal. Along those lines, one of my favorite new features in Access 2007 is Ribbon Extensibility. Writing the XML for a customization can be a bit of a bear, so here is a tip for making this easier.
Before getting started with creating your own customizations, there are a few things you should have:
With Visual Studio or one of the Express editions installed, you can create new file item templates that have portions of the XML of a customization already written. This involves creating the relevant XML and saving it to a particular directory, then modifying a file used by Visual Studio to tell it about the new file that you're adding.
For example, let's say that you wanted to create a new Ribbon customization that started with a blank Ribbon with a single tab with a single group. The XML for the customization might look something like:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true"> <tabs> <tab id="tab1"> <group id="group1"> </group> </tab> </tabs> </ribbon></customUI>
Create a new XML file that uses this customization and save it as RibbonTabAndGroup.xml in the following location: %PROGRAMFILES%Microsoft Visual Studio 8\Common7\IDE\NewFileItems. Change the path to Visual Studio/Visual Web Developer Express if needed.
Next, modify the NewFileItems.vsdir file in the NewFileItems directory to add the new item. For details about this file, check out this article in MSDN. Add the following record to the .vsdir file as the last line of the file.
RibbonTabAndGroup.xml| |RibbonX - Tab and Group|80|Ribbon customization for a blank Ribbon with one tab and one group|#14207|0|0|RibbonXTabGroup.xml
After you add the record to the file, close and re-open Visual Studio. Click the File menu, then choose New and choose File... You should now see the new item in the New File dialog as shown here.
Comments: (4) Collapse
Thanks for this Rob. But I must ask why this sort of customization should be a "bear" at all? I think there is a strong case for MS coming up with a free add-in/wizard that allows creation/customization of Access RibbonBars natively. Also, I have been trying to understand how the various navigation pane Sys tables are used to store the details of the Custom Navigation Pane - again not easy as the GUI ignores direct changes to the Sys table records. Perhaps a wizard would be useful here also, as the native customization dialog is rather basic. Tks
Hi Tony, Thanks for your suggestions! There are actually some solutions available that make this easier such as: pschmid.net/.../ribboncustomizer You might also check out http://www.accessribbon.com/ for some more information about ribbon customizations.
You might also find this tutorial helpful: www.access-freak.com/tutorials.html
Thanks guys!
Comments: (loading) Collapse