Form ribbon does not switch automatically

[Hellgofi]

I am using an Access 2007 as a frontend and SQL 2005 as a backend. (ADP file not an mdb ) I am using 2 ribbons for my application and I have no problem with loading ribbons.

My "MainRibbon" is the one used for navigation thru application. There is one form which has a ribbon called "RecordMenu".


When I open the application my mainribbon appears (set thru Accessoptions). On the main ribbon, I click a button which opens a form and this form has its own ribbon called RecordMenu.

The strange thing is that when I open that form, RecordMenu ribbon does also appears in addition to MainRibbon (start from scratch value is false for both ribbons) but RecordMenu ribbon is not automatically switched, ie, I have to click that ribbon to see it.

I was expecting that if form has a specific ribbon (defined thru form properties) , when the form is opened its ribbon also will be loaded and switched automatically.

What I am doing wrong? I also tried to define ribbon name in form's load event as me.ribbon="RecordMenu" but I am not getting that ribbon automatically switched.

Any help will be highly appreciated.

regards

 

[Hellgofi]

any comment?

 

[tranchemontaigne]

I don't know MS Access 2007, but with older versions sometimes toolbars stop changing. This has happened due to either

1) memory leak - fixable by a cold reboot

2) code that deliberately turns off toolbars

I hope this helps guide your thoughts. Sorry I cannot be more specific.
________
Iolite Vaporizer Review

 

[Hellgofi]

thank you for your comment mate but it's not the case unfortunately. Builtin toolbar menu in Acc 2003 was quite handy and quick. On the other hand ribbons, as far as I can see, offer more flexibility and more chic look.

thank you.

 

[Hellgofi]

it think I found the solution, in the following web page
http://msdn.microsoft.com/en-us/library/bb187398.aspx

it says something about "contextual tabset" and "TabSetFormReportExtensibility" which tell Access that "this ribbon should be displayed when related form or report is opened". I'll give it a try.

It's strange that if we are defining a ribbon in form/report property then the default behaviour should be that ribbon should got focus when related form/report is opened.

hope it solves my problem and others having the same issue.

regards.

 

[Hellgofi]

yes it solves the problem, you should add following tags to ribbon xml file.

<contextualTabs>
<tabSet idMso="TabSetFormReportExtensibility">
,,,,
xml code
,,,
</tabSet>
</contextualTabs>