asked on

IDBE Ribbon Creator

Hi

Has anybody used the IDBE Ribbon Creator. I have just purchassed. I have created a basic database to practice on so far I have created a TAB,Group and a Button in that group. My question how do we get code behind the button to do something like opening a form.
Would that have something to do with the USysRibbons table. I have created the table with the following fields ID, Ribbonname and RibbonXml. I got onto the authors but they just sent a FAQ which doesn't answer my question.

chestera

SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Scott McDaniel (EE MVE )

When you've created the ribbon using RC, you then click on "Update Access Database" in the Finish tab. When you do that, RC will add several modules to the database, and those modules are where you setup the code you wish to run when the user interacts with your ribbon.

Depending on which options you selected when updating the database, those actions are either listed as individual Subs in basRibbonCallbacks, or they're in a single Sub in basRibbonCallbacks with a Select Case statement.

As mx said, be sure to do this on a test database first. Once you get the hang of it it's quite easy, but it can be a little confusing at first.

chestera

ASKER

DatabaseMX

Thank you for that link. I have been looking at some code in the USysRibbon RibbonXml field. sort of getting the idea.

I will look at some of those example dB's and get back to you

Alan

chestera

ASKER

Scott McDaniel

I am using a Test dB and have got has far as Adding Tabs, Groups and at the moment Buttons. Some of the options in the Finish section are a bit confusing. I have noticed the three modules created after Update Access Database. After selecting the Update button the cursor changes into that little busy circle but in my case doesn't want to stop so this afternoon I aborted but it seemed to have done it's job. I thought when finished the normal cursor would return. Am I doing something wrong. The busy cursor lasted well over half hour before I aborted.

Alan

ASKER CERTIFIED SOLUTION

Scott McDaniel (EE MVE )

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

"Once you get the hang of it it's quite easy, but it can be a little confusing at first."
Ditto.

chestera

ASKER

Scott McDaniel

Good morning Scott

Thank you for that Info most appreciated. Ref the busy cursor, I am using a test dB one table and one form at the moment. Once selecting the Update button how long should it normally take with a very small dB

Alan

chestera

ASKER

DatabaseMX

Yep it's looking better all the time. No where as simple as 2003

Alan

chestera

ASKER

DatabaseMX

Hi MX

I have to put aside the Ribbon creator for a few days something has come up. I will close and reopen if any more questions. You and scott have gieven me enough info to get started.

Alan

chestera

ASKER

Thank Scott and MX.