Copying a custom menu bar

[Neil]

I have a form that has its own custom menu bar in Access 2000. I'd like to
make a copy of the menu bar and use it with another form. How can I do this?
Thanks.

 

[Stuart McCall]

I have a form that has its own custom menu bar in Access 2000. I'd like to
make a copy of the menu bar and use it with another form. How can I do
this? Thanks.

Right click on any toolbar and select Customize. Click the 'New' button and
give it a name, then Ctrl-drag your controls from the old to the new
toolbar.

 

[Neil]

Yeah, there are a lot of menu items and submenu items, and I was hoping to
avoid all that hassle.

I found a way to do it, indirectly. Was hoping for a more direct approach,
but this way worked.

I made a copy of the MDB file, went into the copy, and renamed the menu bar
that I wanted to copy to a different name. Then, in the original MDB I did
an Import from the MDB copy, importing only menu bars and tool bars. Since
all the menu bars and toolbars are the same name as in the original, they
don't import. The only thing that imports is the renamed menu bar, which
becomes a copy of the original in the MDB file.

So that worked. But a simple Copy Toolbar function would have been nice.

Thanks,

Neil

 

[Guest]

But a simple Copy Toolbar function would have been nice.<<

You might submit that here as a SUGGESTION TO MICROSOFT because I do believe
that they gather those suggestions. You never know - you might help add
something functional into the next version (although the tool bar thing will
be the ribbon thing and all...)
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[Neil]

Is that the same Microsoft that tried to kill Jet a few years back?
Something tells me that adding new functionality into Access isn't a top
priority for them. OK, they did put a lot of new stuff into 07 -- but it's
all user-oriented stuff, almost nothing programmer-oriented. Or am I
oversimplifying?

 

[Guest]

Just remember, that MS reversed themselves when the uproar about DAO came
about, AND I know that there have been several changes based on MVP input
over several versions. I know that it may look like they aren't listening at
times, but I think for the most part they are really trying to make positive
changes.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[josephmendez]

I have a form that has its own custom menu bar in Access 2000. I'd like to
make a copy of the menu bar and use it with another form. How can I do
this? Thanks.

 

[Neil]

Well, that's good to know. And, certainly with Google on the rise, they're
probably feeling a lot more humble these days anyway. ;-) Thanks for the
input.

 

[Neil]

I take back what I wrote about finding a way to do it by copying the MDB,
renaming the toolbar, and then importing it into the MDB as a new toolbar.
While that technically worked, it really didn't. I ended up with two copies
of the same toolbar, inextricably linked! When I modify one, the other is
modified as well!

In other words: I started out with ToolbarA. Copied the MDB and renamed it
to ToolbarB. Imported toolbars from the copy and then had a ToolbarA and a
ToolbarB in the original db. However, when I add or remove an item from
ToolbarB, ToolbarA is modified. So they're really the same toolbar, but with
two instances in the database. Very weird.

Anyway, just thought I'd post it here as a follow-up.

Neil