?
Solved

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

Posted on 2016-08-12
2
Medium Priority
?
38 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 14

Accepted Solution

by:
wsh2 earned 2000 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 85
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

771 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