Solved

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

Posted on 2016-08-12
2
33 Views
Last Modified: 2016-08-13
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?

TIA!
Dennis
0
Comment
Question by:Dennis_Gundersen
2 Comments
 
LVL 14

Accepted Solution

by:
wsh2 earned 500 total points
ID: 41754782
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!
0
 
LVL 84
ID: 41754786
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:

http://www.avenius.de/en/
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question