By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

Interesting bug with Access 2007 ribbon menus

P: n/a
ARC
Well, maybe not interesting, more like hair-pulling.

Ok, so if you want to code misc. utilities and forms for the office button
(Like a registration screen, backup, setup options, connect to other
database, and the like), you can add your own options to the office button.

However, when you set your application to the main ribbon (with the office
button extra entries), then have individual form ribbons where
"StartFromScratch = True", then with the form ribbon menus, unfortunately,
your custom additions to the office button or not visible when your form
ribbon is.

I tried the following, and the results were mixed:

1) Add the custom office command to each form ribbon. Here's the major bug
with that: If you have a form ribbon open, click the office button to run a
task, close the form ribbon, then click the office button again, all your
menu entries are doubled. Repeat the above steps, and they are then tripled,
and so-on.

2) Final solution was to set each form menu to "StartFromScratch" = false.
However, the problem with this is when you open a form, the "tab" for the
form ribbon will open in the last tab slot, and therefore the form's ribbon
will not be visible when you open the form, unless you right click the tab
in the ribbon (only left-most tabs are active/visible, unless you click the
others). Solution to this: hiding the main menu tab on form Activate, AND
adding a copy of the main ribbon to each form ribbon (so they can switch to
different screens). This forces the copy of the main ribbon to the right of
the form ribbon, and therefore the form ribbon is visible when you click a
form. Then on the de-activate of the form, I'm making the main form ribbon
visible again. Messy solution , but it works.

Just wanted to post this in case anyone has found the same, or found better
alternatives.

Andy

Oct 5 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.