473,385 Members | 1,465 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 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 1632

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
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.