?
Solved

Microsoft Access 2007 and custom toolbars

Posted on 2009-02-16
2
Medium Priority
?
1,663 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
0
Comment
Question by:BJTurner
2 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 23658508
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
0
 

Author Comment

by:BJTurner
ID: 23659147
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.
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question