We help IT Professionals succeed at work.
Get Started
Troubleshooting Question

IDBE Ribbon Creator does not have a way enter OnAction for dropdowns for Access

Lenny Gray
Lenny Gray asked
Last Modified: 2020-08-11
I am using a fully registered IDBE Ribbon Creator 2019 to generate a ribbon for a huge project.

I have run into a problem and need guidance.

I have dropdowns, but there is no OnAction control to fill in for each dropdown selection. How can I call procedures from the dropdowns? Look in the "control files" dropdown (Group grp1, Controls ddc_14). What code do I have to add in the XML to create an ONAction?

Look in RibbonXML.txt for thsi code:
<group id="grp1" autoScale="false" centerVertically="false" label="Data Entry" getVisible ="GetVisible" tag = "RibbonName:=;inMenu:=;CustomTagValue1:=;CustomTagValue2:=;CustomTagValue3:=;CustomPicture:=;CustomPicturePath:=" >
          <button id="btn4" size="normal" label="Project Data Entry" imageMso="HelpKeyboardShortcuts" tag="RibbonName:=ProjectMainRibbon;inMenu:=;CustomTagValue1:=;CustomTagValue2:=;CustomTagValue3:=;CustomPicture:=;CustomPicturePath:=" onAction="OnActionButton" getVisible="GetVisible" getEnabled="GetEnabled" />
          <dropDown id="ddc_14" label="Control Files" imageMso="DatabaseCopyDatabaseFile" onAction="OnActionDropDown" getVisible="GetVisible" getEnabled="GetEnabled" tag="RibbonName:=ProjectMainRibbon;inMenu:=;CustomTagValue1:=;CustomTagValue2:=;CustomTagValue3:=;DefaultValue:=;CustomPicture:=;CustomPicturePath:=">
             <item id="ddc_14Item0" label="Area Maintenance Engineer" />

<item id="ddc_14Item0" label="Area Maintenance Engineer" /> is the first dropdown that needs an OnAction {  the proc name to call is "AreaMaintenanceEngineer_CF_Data()   }

I am developing the ribbon is a sandbox on my workstation at home and want to transfer the new ribbon to the project in development whuch is on their network. These are my questions and assumptions:
  1. I assume that I copy the xml code from RibbonXML.txt into the sandbox Ribbon table USysRibbons
  2. I assume that I copy the three bas modules to the sandbox modules
  3. Where is the ribbon stored in GA for the dialog Select Ribbon: ? (ProjectMainRibbon)
  4. What do I do with Callbacks.txt? 
  5. Is there any other code to temporarily transfer to my client site?
  6. When my client gets a license (which is soon), what do I transfer from my sandbox to their installation? 
  7. How can I get back to the "normal" ribbon in the sandbox? Is there a way to switch from the custom ribbon to the new ribbon and back? Is my only choice to delete the custom ribbon name and then restart Access?
  8. Is there a programmatic way to have multiple custom ribbons and the "normal ribbon"? I would like to have the data entry screens have their own ribbon like in the "old days" of commandbars.

Attached is the sandbox access database  


If you need more items, tell me where to find them and I'll send them.

Thanks, in advance!

Lenny Gray

Watch Question
Senior Developer
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant

An Experts Exchange subscription includes unlimited access to online courses.

Get Started
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE