Making a Custom Ribbon in Microsoft Access - Part 1

Setting up the ribbon and making it display - the basics.
**The XML shown in this video can be found at:
accessjitsu.com/2015/09/13/cod...
A custom ribbon in an Access application can serve two purposes. It can be part of a strategy to keep users from accidentally making design changes to an application you have built. It can also add a nice bit of "polish" to an application, giving it a more professional look by providing easy access to features provided by the application.
In this video we will:
1. Create a table to hold our ribbon XML
2. Use an XML editor to build some very basic ribbon XML
3. Build a form to display and edit the ribbon XML we load into the XML table
4. Copy our XML into the form/table
5. Choose which ribbon to display
All of my videos organized by topic and other blog topics:
accessjitsu.com/
This will be a multi-part series. In subsequent videos we will discuss:
1. How to show and hide built-in ribbon groups and individual ribbon controls (items delivered as part of Access).
2. The code needed to perform some action based on interaction with the ribbon, like a button click.
3. Code to make the ribbon respond to the user interface.
4. How to add images that are built into Microsoft Office.
5. How to add custom images that you have created.

[@user-xk6oz5oh2c]

This is INCREDIBLE! I am going to share this with my whole class!! You are my new hero no joke.

[@Oswee]

Very COOL voice and great teaching skills! Thank You for Your work!

[@Y2luisroman]

Excellent videos. Very impress with the code and techniques that you share. Thank you very much.

[@huytruong2026]

This is amazing. I can't believe you taught us this for free.

[@easywest1]

Thanks for the great video! It was exactly what I was looking for.

[@babyintank1835]

Thanks bro! This clip helped me a lot!

[@clovisblock7524]

Excellent video, excellent teaching. Congratulations and thanks from Brazil.

[@fi2lwa]

It is a great video. Very useful.

[@freebird7556]

Great!!!! very simple and giving very core. Thank you so much..

[@tihomirpopovich]

It is full OK! Thank you

[@pakenhampastoralcharge6108]

Thanks for a great series. I am working through it with Access 365 and Visual Studio 2022 and have run into two problems; 1) Trivial but annoying - all formatting is lost when I cut and paste the xml code into the form. 2) When I attempted to change the showFromScratch from false to true for the user ribbon, it was impossible to type correctly in the xml data field in Access. Could that have something to do with the fact that there is no longer a Memo type. I had to use Long Text instead. Thanks!

[@robertcarroll5036]

Hi Jim, Great videos! Can you actually have it so there is no ribbon and that the whole db is run from command buttons within the forms?

[@johnclark851]

A little late to the party here. Excellent series, thank you so much for sharing. I noticed this series about a year ago and told myself that going forward, I would use this approach. One question, and I apologize if you covered this. I watched this series twice and did not see an answer: How do you remove/hide/disable the File tab?

[@abuahmadsp]

good tutorial

[@muneeralhassan4724]

I got a Custom UI Runtime Error Error found in Custom UI XML of "Send to Bluetooth": Line:1 Column:199 Error Code 0xC00CEE21 Whitespace expected It affect all office components

[@vincentchikobe649]

Just watching but its not clear zooming would be some kind of great amazing work

[@rosdibinahmad2956]

superb

[@qualitychemical6235]

Do you do consulting (programming help) for an hourly rate?

[@christopherfischer3939]

Halfway through the videos and they're great!. My only complaint is the sound is too low when you recorded. I have the volume at maximum and I can barely hear you. Also, be sure to let everyone know they need to have Microsoft Office Object Library reference selected to do the programming.

[@micron001]

Ditto on the sound. Maybe move 20 feet closer to the mike? Re-publish with more volume? It's like it's on level 1 out of 20.

[@ahogadicimo]

I got a Custome UI Runtime Error....error code 0xCoocee2D line 1 column 1 and line 1 column 9

[@johnukos]

did you figure out the issue?

[@rhodnill5906]

hello did you figure out the issue? Thanks

[@rayghartey741]

the link to XML file is broken