deleted a custom menu bar, now getting macro error

[Donna]

I created a custom menu bar a few years ago. It included the ability to open
a dialog box that lets the user select various reports to preview or print.
The database underwent some major modifications, including renaming all these
reports. I decided to delete the customized menu bar and start over with a
new one. Now I get an error that says the macro doesn't exist for the menu
bar. I can get this error upon opening the database and/or when trying to
select a report to preview/print from the prints dialog form.

I went to the customize toolbars menu and renamed the "new" menu bar to the
"old" name and it seemed to be happy. It works okay on my pc, but the other
fellow who uses this database gets the same error I had. So... we renamed the
menu bar to the old name and he can get to the reports until he closes the
database. When he reopens the database, the error message is there, only this
time its looking for the other menu bar and he has to rename it again in
order to get to the reports.

Is there a way to get to the underlying macro group that Access created to
go with the menu bar?

The other workaround I've considered is to duplicate the menu bar that is
working and give it the old name. I'd essentially have 2 identical menu bars
with different names, could hide one and show the other. Would like to know
if there is a better way before I do that. Any suggestions?

 

[Albert D. Kallal]

I am guessing, but your problem may very well be that the form, or report
still has the "name" setting for the old custom menu bar.


Open up the form (or report) that gives the error message in design mode.

check the "other" properties sheet tab, and take a look at the settings for
the menu bar...you should likely remove the old setting.

Is there a way to get to the underlying macro group that Access created to
go with the menu bar?

A custom menu bar can call eitiher standard VBA code in a form, or a module,
or the custom menu bar can also run a macro....

However, as mentoned, it likey that your form, or reprot has a "setting" to
the old menu bar...simly change that setting, or remove it as explained
above...

 

[Donna]

ohhh crap... that's the problem. Must have set that up a few years ago and
totally forgot about it. No wonder it was kicking up an error. Unfortunately
for me, it wasn't the form, it was most of the reports. Now I get to go back
into the design of each report and remove that. There's only about 30
reports, that shouldn't take long. LOL Thank you for the quick response.

Never too old to learn.... Donna

 

[Bob Quintal]

ohhh crap... that's the problem. Must have set that up a few years
ago and totally forgot about it. No wonder it was kicking up an
error. Unfortunately for me, it wasn't the form, it was most of
the reports. Now I get to go back into the design of each report
and remove that. There's only about 30 reports, that shouldn't
take long. LOL Thank you for the quick response.

Never too old to learn.... Donna

One additional point, if the other user's copy of the database has
the :Name Auto Correct feature enabled it may be renaming the
menubar to its original name after closing the database. It is
sometimes called Name Auto Corrupt,with good reason.

Tools->options->general->Name AutoCorrect

Q