I am using the following code to replace the toolbar on all my reports with
a custom ribbon. It adds the ribbon but will not delete the toolbar. How can
I delete the reference to the old custom toolbar?

Dim rpt As AccessObject
Dim i As Integer

For Each rpt In CurrentProject.AllReports
DoCmd.OpenReport rpt.Name, acViewDesign, , , acHidden
Reports(rpt.Name).RibbonName = "PrintPrev"
Reports(rpt.Name).Toolbar = ""
DoCmd.Close acReport, rpt.Name, acSaveYes
Next

paii, Ron wrote:

Any possibility it's the Menubar, not Toolbar, that needs to be updated?

"Salad" <salad (AT) oilandvinegar (DOT) com> wrote

I just tried that and it did not work. I also tried
Reports(rpt.Name).Toolbar = "x", thinking Toolbar would not accept ZLS, but
NG. As a test I did Reports(rpt.Name).Menubar = "y", which set the menubar
to "y".

paii, Ron wrote:

Sub r()
Dim dbs As Database
Dim doc As Document
Dim rpt As Report

Set dbs = CurrentDb

With dbs.Containers!Reports
For Each doc In .Documents
DoCmd.OpenReport doc.Name, acViewDesign
Set rpt = Reports(doc.Name)
MsgBox doc.Name & " " & rpt.Toolbar
rpt.Toolbar = ""
Set rpt = Nothing
DoCmd.Close acReport, doc.Name, acSaveYes

Exit For 'test on one report, remove if works

Next
End With
End Sub

"Salad" <salad (AT) oilandvinegar (DOT) com> wrote

I tried your code, as you expected, it did not work. By the way, this is for
Access 2010.

Thanks for the help

paii, Ron wrote:
What happens if you do it manually?

Who knows, maybe it's keeping it for an older system like A2003. Does
it affect the system at all? Is it converted to A2010 format?

"Salad" <salad (AT) oilandvinegar (DOT) com> wrote

I can delete it manually, which will allow me to open the report without the
old toolbars imported into the MDB
I have converted the MDB from Access 97 to 2010 by both having Access
convert a copy, and opening a blank database and importing all the objects
from A97 mdb. In the current version, I opened a blanked database and
imported from a converted copy.

I am looking to automate because of the need to run the application using
both A97 and A2010 depending on the workstation. So I need to automate
converting from A97 to A2010 when changes are made.

On 9/3/10 12:49 PM, paii, Ron wrote:
Wouldn't it be simpler to just hide the toolbars instead of wiping them
out when you convert? IINM, by default, the toolbars goto into AddIns;
just throw a custom XML that suppress the AddIns tab. Will that do it?

paii, Ron wrote:

If you do it manually does that help?

"Banana" <Banana (AT) Republic (DOT) com> wrote

Yes it would be simpler, and during my 1st tests I imported the toolbars.
But they are something that is not needed in A2010.