• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 48
  • Last Modified:

Access: How do I programatically create and/or add a custom ribbon menu on file open?

I'd like a custom made ribbon to be added to Access (and the others hidden) when I open a specific file. I need a few buttons on it connected to macros (or directly to VBA if possible) with names and images. The ribbon should be automatically removed when the file is closed.

Is there a tutorial about this somewhere?

1 Solution
Here is a 4 part video series covering everything about MsAccess ribbons (including VBA interaction):

Making a Custom Ribbon in Microsoft Access
Part 1:  https://www.youtube.com/watch?v=Zt3F4_Z5LIw
Part 2:  https://www.youtube.com/watch?v=6dIqHMpJrh8
Part 3:  https://www.youtube.com/watch?v=kBD_eYEgie4
Part 4:  https://www.youtube.com/watch?v=2YW_eDeCz3E

Many thanks to "Access Jitsu" for his excellent scholarship in making these videos!
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Setting a specific ribbon to show when you open a specific Access file is fairly straight forward. You just add the XML to the USysRibbons table, and select the name in the Access Options - Current Database - Ribbon and Toolbar Options.

Far more difficult is actually creating the ribbon, which can be a HUGE PITA. In my opinion, if you must create custom ribbons the tool to use is Gunter's RibbonCreator:

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now