Ribbon in Runtime

Question

Can someone point me to a simple example of taking a custom tab on a ribbon that I created in an accdb file and making it show up in the accde file that I distribute to my users?

Answer 1

Do you mean that you used the "customize" ribbon option, and made/added changes to the ribbon? And then you want that part to be used as a ribbon?

Yes.

You can export the current customizing you done above, and then simply "remove" the "very" first part of the ribbon, eg this part:

<mso:cmd app="Access" dt="0" />

If you remove above, then the rest of the xml can simply be pasted into the USYSRibbons table, and should work.

So it not 100% clear if you talking above having used the "customize" ribbon - but the above will allow you to take such customizing and create a separate ribbon.

If you built the ribbon yourself as XML and again saved such xml in the USYSRibbons table, then to simply display that tab you built, just specify the ribbon in the other tab of the form (when in design mode), and when that form is launched, then the custom ribbon tab you have will display.

This process will/should work for the full version of Access and also that of the runtime - so there not really a "different" process here. How you set this up for the full version of Access vs runtime is really much the same.

Regards,

Albert D. Kallal (Access MVP)

Edmonton, Alberta Canada