Solved

IDBE Ribbon Creator

Posted on 2014-04-02
10
974 Views
Last Modified: 2014-04-04
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
0
Comment
Question by:chestera
  • 6
  • 2
  • 2
10 Comments
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 250 total points
Comment Utility
Hey Alan ...
I'm 99% sure if you download the sample dbs at Gunter's link below,  you will find everything you need:

http://www.accessribbon.de/en/index.php?Downloads

I've been using RC2010 (and 2013) for more than a year ... and it's outstanding!
Initially, I download *every* sample and checked them out. I have them all in a special folder group.

And yes ... a 'practice'  db is the way to go. Be *sure* you understand exactly what every option does, especially on the 'Finish' tab.

I will try to help as time permits.

mx
0
 
LVL 84
Comment Utility
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.
0
 

Author Comment

by:chestera
Comment Utility
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
0
 

Author Comment

by:chestera
Comment Utility
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
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
Comment Utility
I'd suspect the long busy cursor has more to do with the database than with Ribbon Creator. Before working with a db in RC, you should make a backup, and then Compact the database. AFTER doing that, open RC and select the newly compacted database.

The options are somewhat confusing. The important ones are:

Copy 'basRibbonCallbacks" to the database
always checked, but beware that this may overwrite your current basRibbonCallbacks.
Copy 'basGDIPlus" to the database
always checked

These are somewhat optional:

Set Ribbon as Application Ribbon (should only do that for your "Main" ribbon)
Save images in the selected database (if you want to)
Keep Callback calls in the XML Ribbon (not really sure about this one)

The most confusing, and ones that can cause some hair-pulling:

Replace "basRibbonCallbacks" in the selected database
BE SURE that you have a backup of the existing basRibbonCallbacks before doing this. Enabling this will overwrite that entire module, and you will lose any changes you've made there. In general, once you've added code for those "action" items in the module, you should NOT allow RC to replace it unless you really, really are sure.
Add Select Case Statements for all Controls in basRibbonCallbacks
I use this one, since I prefer to have a single SELECT CASE structure to manage my actions for the ribbons. If you do not check this, RC will create separate Subs for each Ribbon Item action. This is somewhat unwieldy to me, but of course you may prefer that method.
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
"Once you get the hang of it it's quite easy, but it can be a little confusing at first."
Ditto.
0
 

Author Comment

by:chestera
Comment Utility
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
0
 

Author Comment

by:chestera
Comment Utility
DatabaseMX

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

Alan
0
 

Author Comment

by:chestera
Comment Utility
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
0
 

Author Closing Comment

by:chestera
Comment Utility
Thank Scott and MX.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

743 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now