Customizing The Microsoft Access Ribbon, Part 2

Welcome

This is part two of my series on custom ribbons, and today we're going to focus on customizing the ribbon and context menus.

First, we'll look at how to create a custom gallery and work with the Backstage view to hide unwanted options. Then, you'll learn how to add your own items to the Backstage tab menu and create Quick Access Toolbars for specific forms or reports.

We'll also cover how to replace the hidden system tables with your own custom ribbon table and load ribbons using VBA.

After that, we'll move on to the highly requested topic of custom right-click context menus, showing you how to customize them, add buttons with custom actions, and even load your own images into those buttons.

Resources

• Full Course Lessons Page
• Course Topic Outline

Topics Covered

In Lesson 1, we continue working on customizing the ribbon. We'll learn how to create a gallery and a custom menu on the ribbon. Then, we'll start working with the Backstage, which is another name for the File menu. We'll see how to hide print options and most of the other menu options, except for the Home menu option.

In Lesson 2, I'm going to show you how to add your own items to a Backstage tab menu. You can add your own categories, buttons, and all kinds of things directly on the Backstage, right on the File menu.

Lesson 3 is nice, short, and simple. I'm going to show you how to create custom Quick Access Toolbars for specific forms or reports. It's easy to do this for the whole database in File Options. But if you want a custom Quick Access Toolbar for each specific form, you can do that with this technique.

In Lesson 4, we're going to get rid of that hidden system table called USysRibbons. We're not going to use it. I don't like messing with hidden system tables at all. So we're going to create our own custom RibbonT table. Then, we'll use Application.LoadCustomUI to load our own ribbons instead of relying on that system table. We'll do that on startup, and I'll show you how to work that into the database.

In Lesson 5, we're going to start talking about what everybody's been emailing me about: right-click context menus, those right-click pop-up menus. We're going to start working on those in this lesson.

In Lesson 6, we continue with custom context menus. I'm going to show you how to figure out the built-in button IDs. We're going to loop through all the controls and build a form where we can search for a control by name to get its ID. It'll be pretty cool.

In Lesson 7, we are finishing up with context menus. We're going to learn how to make custom buttons on your right-click pop-up menus. We'll learn about the OnAction event to add custom functions behind those buttons, so you can click on a button and have it do whatever you want. We'll also see how to use FaceIDs for the built-in icons or LoadPicture to load your own custom images in your buttons, like my pretty face.

Enroll Today

Enroll now so that you can participate with us as the videos are posted.

Questions?

Please feel free to post your questions or comments below. If you are not sure as to whether or not this product will meet your needs, I'd rather help you before you buy it. Remember, all sales are final. Thank you.

Keywords

microsoft access, access 2016, access 2019, access 2021, access 365, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, custom ribbons, Microsoft Access ribbons, Access ribbon customization, Access ribbon gallery, Backstage view Access, custom menus Access, Access Quick Access Toolbar, VBA ribbon customization, Access context menus, right-click menus Access, Access context menu customization, custom button Access, OnAction event Access, LoadPicture Access, FaceID Access, ribbon table Access, Access tutorial ribbons, custom icons Access, Access VBA ribbons