468,765 Members | 1,144 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,765 developers. It's quick & easy.

Interesting bug with Access 2007 ribbon menus

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
0 1489

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

37 posts views Thread by jasmith | last post: by
27 posts views Thread by Wayne | last post: by
7 posts views Thread by denuk2003 | last post: by
4 posts views Thread by Samuel | last post: by
2 posts views Thread by D Hammer - Sayner | last post: by
14 posts views Thread by frogsteaks | last post: by
10 posts views Thread by prakashwadhwani | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.