Avatar of Norush
NorushFlag for Netherlands asked on

custom toolbar visible by default in Access 2007 application

My Access 2003 applications have a custom toolbar.

In Access 2007 these toolbar are 'hidden' behind the Add-ins ribbon tab.

Is there anyway i can make these toolbars visible by default without having users to click in the Add-ins ribbon?
screen.jpg
Microsoft Access

Avatar of undefined
Last Comment
koutny

8/22/2022 - Mon
tbsgadi

koutny

I too am struggling with this new 'feature'.

I looked at the code in the other thread Gary mentioned but while it probably works (in that it displays the right menu bars within the Add ins ribbon) it doesn't really solve the problem which I think Norush is having as well - the users still need to go to the Add ins tab first if they want to access the custom menu / tool bar.

Also, if you switch to a different form and come back, the ribbon is not selected anymore and you have to select it again!

It would be great if it was possible to select the Add ins ribbon via code, say within the On Activate event. But I have a feeling that it might not be possible, at least not if one is not prepared to maintain two versions of the application - one coded for Access 2007 and one for the older versions.
tbsgadi

I just use DoCmd.ShowToolbar "MyToolbar" & it works fine
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
koutny

OK, I will have to try that again.  I don't have an Access 2007 machine here so will test it later and report back.
ASKER
Norush

The showing of the Add-ins tab is not the problem.

I want to prevent that users have to click on it first in order to see my custom toolbar.

I want the Add-ins tab expanded by default
tbsgadi

In tools Startup try unticking "allow Full menus"
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Norush

Not what i was hoping for but it does answer the question.
koutny

I found out there is a way even without using some special software.
You need to untick the check box Allow Built-in Toolbars in Start up options.

You will need to select a default menu from one of your custom menus (can be a copy of the standard menu) which Access 2007 will show instead of the Ribbon. Any forms which have their custom menu will show that menu instead.

I found out about this in this article:
http://msdn.microsoft.com/en-us/library/bb203849.aspx#OfficeAccess2007MigratingExistingApplications_VisualUserInterfaceChanges

in the section Custom menu bars
koutny

Sorry, the previous link takes you into the middle of the article. The beggining is at
http://msdn.microsoft.com/en-us/library/bb203849.aspx
Your help has saved me hundreds of hours of internet surfing.
fblack61