Access 2010 delete custom toolbars

Question

I converted our Access 2002 database to Access 2010. I want to delete the old Access 2002 custom toolbars.

How can I do that?

Where are the custom toolbars located in access 2010?

Thanks

Answer 1

If you know the names of the toolbars, you can delete them as follows:

• Press Ctrl+G to activate the Immediate window in the Visual Basic Editor.
• Type

CommandBars("ToolbarName").Delete

where ToolbarName is the name of a custom toolbar.

• Press Enter.

Answer 2

I realize this is an old request, but I have been looking for an answer to the same questions and was never really successful in finding a solution. I finally found my problem and thought I would share it here just in case it helps someone else.

I was able to delete the custom toolbars by importing all components of the old database (e.g. tables, forms, queries, etc) into a blank Access 2010 database. But I still kept getting an annoying "Microsoft Access could not find the toolbar "MyCustomToolbar". So it obviously deleted it, but something was still looking for it!

I searched all of the VB code for "Toolbar", "Menu", anything I could think of and could not find anything in the code that referenced custom toolbars. What I DID find, was that certain forms were attempting to invoke those toolbars in their Properties. I had a handful of forms that were doing this and this is how you find them.

SOLUTION:

Open up a form's Property Sheet and select the "Other" tab. In that tab were variables "Toolbar" and "Menu Bar", each of which was filled in with my custom Toolbar from the original database. Clear out any of the entries related to your custom toolbar and the messages disappear!

I hope this tidbit helps other users from spending the hours that I did trying to track down this annoyance.

Answer 3

Custom toolbars are displayed in the Add-Ins tab of the ribbon.

Right-click a custom toolbar and select "Delete Custom Toolbar" to remove it.

Answer 4

Problem is that Custom Toolbar and Menu Commands are grayed out in Add-Ins of the Ribbon.