Access 2007 - Create custom toolbar for Add-Ins tab

[jkirkland]

I am re-creating an Access 2003 program in Access 2007. I had a custom toolbar in the older version.

Does anyone know the code to make a custom toolbar on the Add-Ins tab for Access 2007?

The command: application.commandbars.add does not seem to work.

Thanks!

 

[jkirkland]

I figured it out. You can still create custom toolbars using:

dim cmdBar as CommandBar
Set cmdBar = CommandBars.Add("CustomToolbar", msoBarTop)
Set cmdBar = Application.CommandBars("CustomToolbar")
etc, etc

To make the 'Add-Ins' tab appear with this commandbar, insert the following at the end of the procedure:

cmdBar.Visible = True