We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Microsoft Access 2007 and custom toolbars

BJTurner
BJTurner asked
on
Medium Priority
1,706 Views
Last Modified: 2013-11-28
I have inherited a database created by someone else.  I am unsure what version of Access the database was created in, but the users are now using Access 2007 and I am attempting to develop in 2007.  The new interface is very much different and confusing and I cannot seem to find the custom toolbars.

The original developer created custom toolbars for the forms.  When I look at the property sheet on the forms, I see the toolbar names in the Toolbar property.  However, in Design view I do not see the custom toolbar, nor can I seem to find it.

I tried Google, but the best I can tell it is supposed to be an add-in.  I don't see anything under add-ins in Access 2007.  On one page it showed a screen shot and there was a tab next to the Database Tools tab for Add-ins.  I don't have that.  If I select Database Tools/Database Tools/Add-ins, I don't have any selection of add-ins and I don't know where to find one.  

The custom toolbar works.  However, I can't seem to find it to update it with changes I want to make.

I have attached three screen shots.  The Access Ribbon, shows the view when I open the database without an object open.  The second, Form Design View Ribbon, shows the view I get when I am in the Design View of the form that has the toolbar.  The third, Form Property Sheet shows the property sheet of the form and shows that the Toolbar value is set.

Can someone help me find this toolbar where I can edit it?

Thank you.

Tammy
ToolbarIssue.zip
Comment
Watch Question

MIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012
Commented:
BJTurner,

"Toolbars" as they existed in previous version, no longer exist in Access 2007.

I belive there is a way to display them.
I am not sure if you can still "Modify" them though.

You will have to become wise in the ways of the Ribbon.
;-)
http://msdn.microsoft.com/en-us/library/aa338202.aspx
(Happy Reading)

;-)

JeffCoachman

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thank you.  That is what I thought from what I read.  We are going to have to determine if we continue developing in 2007 or go back to 2003.  You can develop the command bar in 2003 and it works in 2007.  You just can't see the code.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.