asked on MS Access custom ribbon - can't seem to get it working
I have been trying to create a custom ribbon in MS Access 365 so that when others/users open the frontend of the database they will see a custom ribbon instead of the standard MS Access ribbon.
I created the table and started the XML (not my forte), but almost all the examples use a schema from 2006 (the only one I found that wasn't 2006 was this one which my xml editor complains about <customUI xmlns:x1="http://schemas.microsoft.com/office/2009/07/customui"> - with or without the ":x1") I get the error "no declaration found for element 'customUI' for the schema.
I am also now getting an error everytime I open an email in outlook. This started happening after I tried to open the access customizations.exportedUI file in the XML editor.
Any help with the problems and created a correct ribbon would be appreciated.
I created the table and started the XML (not my forte), but almost all the examples use a schema from 2006 (the only one I found that wasn't 2006 was this one which my xml editor complains about <customUI xmlns:x1="http://schemas.microsoft.com/office/2009/07/customui"> - with or without the ":x1") I get the error "no declaration found for element 'customUI' for the schema.
I am also now getting an error everytime I open an email in outlook. This started happening after I tried to open the access customizations.exportedUI file in the XML editor.
Any help with the problems and created a correct ribbon would be appreciated.
Microsoft OfficeDatabasesMicrosoft Access
Last Comment
Thomas Zucker-Scharff
ASKER
Thanks John! I'm looking at it now - I didn't realize that your image app had a custom ribbon.
ASKER
What am I doing wrong? I see your code works fine, but as soon as I paste my code in there (below) I get the error attached.customui error.PNG
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" >
<ribbon startFromScratch="true">
<officeMenu>
<button idMso="FileCompactAndRepairDatabase" insertBeforeMso ="FileCloseDatabase" />
</officeMenu>
<tabs>
<tab id="Home" label="Home" visible="true">
<group id="Group1" label="Group 1">
<button id="MainMenu" label="Main Menu"
size="large" supertip="Open the Main Menu"/>
<button id="Form2" label="Form 2"
size="large" supertip="Open Form 2"/>
</group>
<group id="Group2" Label="Group 2">
<button id="Button3" label="Button 3"
size="large" supertip="open the Main Menu"/>
<button id="Button4" label="Button 4"
size="large" supertip="Open Form 2" />
</group>
</tab>
<tab id="Maintenance" label="Maintenance" visible="true">
<group id="GroupM1" label="Group M1">
<button id="Button21" label="Button 21"
size="normal" supertip="small button 21"/>
<button id="Button22" label="Button 22"
size="normal" supertip="small button 22"/>
<button id="Button23" label="Button 23"
size="normal" supertip="small button 23"/>
</group>
<group id="GroupM2" Label="Group M2">
<button id="Button24" label="Button 24"
size="normal" supertip="small button 24"/>
<button id="Button25" label="Button 25"
size="normal" supertip="small button 25"/>
<button id="Button26" label="Button 26"
size="normal" supertip="small button 26"/>
</group>
</tab>
<tab idMso="TabCreate" visible="false" />
<tab id="dbCustomTab" label="A Custom Tab" visible="true">
<group id="dbCustomGroup" label="A Custom Group">
<control idMso="Paste" label="Built-in Paste" enabled="true"/>
</group>
<group id="dbCustomGroup2" label="Another Custom Group">
<control idMso="ImportExcel" label="Import from Excel" enabled="true"/>
<control idMso="ExportExcel" label="Export to Excel" enabled="true"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>
ASKER
I customized a ribbon using the customize ribbon tool in MS Access before I realized that I couldn't embed it into the database. Is there any way to port that to an xml file that access will understand? I tried importing it into an xml editor and editing it, but that didn't seem to work (of course nothing is quite working right now so maybe it really does work ...).
Activate this to pinpoint errors
ASKER
Yes I did that already. That is why I am getting the error I posted - when I turn that off the error goes away.
ASKER
Just playing around with it and my code doesn't even produce a ribbon. I tried getting rid of spacesand matching your code as best I can, but no go :-(
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks for the help, now to get it to actually do something ...
SimpleRibbon.accdb
If you want something more elaborate you can check my Article where besides the loading of Images i do some custom Ribbon
https://www.experts-exchange.com/articles/33716/Defeating-the-device-independent-bitmap-dib-format.html