472,961 Members | 1,798 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,961 software developers and data experts.

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 1612

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

37
by: jasmith | last post by:
How will Access fair in a year? Two years? .... The new version of Access seems to service non programmers as a wizard interface to quickly create databases via a fancy wizard. Furthermore, why...
27
by: Wayne | last post by:
I've been clicking around Access 2007 Beta 2 and can't see the custom menu bar designer. Is it in the beta? Maybe I'm blind. The question that comes to mind is: Will custom menu bars be the same...
7
by: denuk2003 | last post by:
Hi Everybody I have a 2003 application that I am trying to run under 2007, The code seems to work OK but the Ribbon is a big problem. It just takes up too much space away from the application. ...
0
by: fiona | last post by:
Dramatically increases support for accessibility as well as fully conforming to the Office 2007 UI license and guidelines Dorset, United Kingdom - January 3 2007, Divelements Ltd announces the...
2
by: Wayne | last post by:
I've been having a click around Access 2007 this afternoon and have discovered some things that range from annoying to alarming. My Access 2003 menu bars, which I, like many others, use...
4
by: Samuel | last post by:
Hi I would like to implement a toolbar similar to the one in Office 2007 Can anyone tell me if this control is available in VS 2008 Thank you, Samuel
2
by: D Hammer - Sayner | last post by:
I am new to using Access 2007 and a novice with Access period. I have two older databases that I created in Access 2000. When I open DB1 I get the usual ribbon menus shown. When I open DB2...
14
by: frogsteaks | last post by:
Is there a way to get rid of that horrid 'ribbon' and go back to a 'normal' menu structure in '07? I'd like to continue to develop and distribute databases (preferrably with the access run time)...
10
by: prakashwadhwani | last post by:
Office 2007 & thus Access has had it's menus replaced with the Ribbon Bar. It's very disconcerting. In Word, Excel, Access, I feel totally lost. Also all the shortcut Menu pulldowns don't work...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
2
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.