How to Customize Microsoft Access Ribbon

Today we discover how to make the Microsoft Access Ribbon look like Your Application; Not Access. Get rid of that Ribbon! It is scary stuff! Teach your users to use Your application Not Access.
Main Points:
- In under 5 minutes learn to Customize the Ribbon in Microsoft Access.
- Refer to Top comments for VBA code and XML Code used in video.
Buy the Code:
- Working Code presented in video available on Etsy:
www.etsy.com/l...
Thank you for checking-in at Data Check-in! Your source for all things data using Microsoft Access, Excel and VBA.
- Subscribe to get the latest videos on Microsoft Access, Excel and VBA!

[@accessisnotdead]

'''''''''''COPY AND PASTE INTO A NEW MODULE NAMED: modUSysRibbons ' '************************************************************************************* '1.) Module name: modUSysRibbons. '2.) Go to Tools-->References and check Microsoft Office 16.0 Object Library '3.) Create Tables: 'Table Name: USysRibbons 'Fields: 'ID AutoNumber 'RibbonName Short Text 'RibbonXml Long Text 'Comments Short Text 'Table Name: USysRibbonsImages 'ControlId Short Text 'Images Attachment 'Description Short Text '4.) Form Name: frmUSysRibbonsImages '5.) Create Macro: macOpenOrders '6.) Refer to next comment for XML code for Table USysRibbons 'Access is Alive! 'kzbin.info/door/F1tGDa9oHe-0zD639mNWZw '************************************************************************************* Option Compare Database Option Explicit Public MyRibbon As IRibbonUI Sub OnLoadRibbon(ribbon As IRibbonUI) Set MyRibbon = ribbon End Sub Public Sub getRibbonImages(control As IRibbonControl, ByRef image) Dim attach As Attachment DoCmd.OpenForm "frmUSysRibbonsImages", acNormal, , , , acHidden '************************************************************************************* 'UPDATE TO BUTTON NAME AND IMAGE NAME bSetRibbonImage control, image, "btnOrders", "Orders" 'Example where the Button name is in the XML Code:

[@accessisnotdead]

[@md.omerkhayyam3343]

what could be reason ms access form wizard cannot find the table (USysRibbonImages) ?

[@accessisnotdead]

Hi @md.omerkhayyam3343 If your options to hide System tables is on then USysRibbonImages will be hidden.

[@johnclark851]

Like Nifty, the ribbon was always a "black box" for me. I like your format and you succinct way of explaining things - not bad for a Crazy Cat Lady!

[@accessisnotdead]

@johnclark851 You know it! LOL I figure why not let the cats have a debut :-) Thank you for the compliment on the format. Always open to suggestions to make it easier for all.

[@SLeinert]

Thank you very much for that video! It was a great start and motivation to learn more about how to customize that ribbon. Nice and detailed enough to get started for own projects 👍 thanks!! Now only custom „context menu“ are missing 😅 maybe i will also give it a try again… 😉

[@accessisnotdead]

Great idea for another video! How to customize the right click menu. Be sure to subscribe to be alerted of new videos.

[@SLeinert]

@@accessisnotdead that would be great 😀 subscribe? … already done 😉 your Video was a good inspiration for the start!! Thank you 👍

[@NiftyAccessMicrosoft]

Excellent video thank you. I have never tackled the ribbon myself, always avoided it because it just looked a very complicated process. But now with your instructions, I feel confident I can easily create my own ribbon!

[@accessisnotdead]

@NiftyAccessMicrosoft That comment alone makes all the hard work creating the video worth it! The thing to watch out for is how sensitive the XML code is. Recommend using Notepad++ for editing. Feel free to reply on here if you run into any issues. Happy coding!

[@diomaksolutions]

Nice presentation....awesome!

[@accessisnotdead]

If you have any questions or get stuck on anything let me know. It can take some practice editing the Ribbon.

[@44louix]

@@accessisnotdead Honestly, with your short videos, it's like i have done the practice and i already create 2 tabs with several menus inside, i learned the basic, and now i can do whatever i want, thanks

[@accessisnotdead]

@@44louix Woohoo!!!! Go @44louix!

[@44louix]

HI, thats so cool, would you mind sharing some template with us or any site where i can get some template 🙂

[@accessisnotdead]

Hi @44louix The below link from Microsoft will give you a breakdown of all the different types of XML tags you can use for different menu options. A Template would only be useful if it was for a specific type of application that had common commands, but you are really going to want to customize the menu to what makes sense for your application. learn.microsoft.com/en-us/openspecs/office_standards/ms-customui/700e4451-8706-40c5-8d7b-896e4ae21b69

[@44louix]

@@accessisnotdead Thanks dear You are the best Love you

[@joshua4915]

*Promo sm* 😴

[@accessisnotdead]

Hi. No need to buy anything or subscribe. All the code included in the comments and shown in the video will get you a working custom Ribbon in Access. The Etsy link is incase you do not want to go thru the KZbin tutorial. A $2 shortcut for you but not necessary. I'll be sure to be more clear in future videos. Thank you for the feedback!

[@accessisnotdead]

@joshua4915 I would love to hear your opinion on what made you think the video was a promo. Your opinion matters and helps us to create more helpful videos.