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" <(E-Mail Removed)> wrote in message
news:y4SWi.4015$(E-Mail Removed)...
>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.

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


"Stuart McCall" <(E-Mail Removed)> wrote in message
news:fggsol$nd3$1$(E-Mail Removed)...
> "Neil" <(E-Mail Removed)> wrote in message
> news:y4SWi.4015$(E-Mail Removed)...
>>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.
>
>
>
>
>

>>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" wrote:

> 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
>
>
> "Stuart McCall" <(E-Mail Removed)> wrote in message
> news:fggsol$nd3$1$(E-Mail Removed)...
> > "Neil" <(E-Mail Removed)> wrote in message
> > news:y4SWi.4015$(E-Mail Removed)...
> >>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.
> >
> >
> >
> >
> >
>
>
>

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?


"boblarson" <(E-Mail Removed)> wrote in message
news:39896405-A832-4E91-8DB5-(E-Mail Removed)...
>>>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" wrote:
>
>> 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
>>
>>
>> "Stuart McCall" <(E-Mail Removed)> wrote in message
>> news:fggsol$nd3$1$(E-Mail Removed)...
>> > "Neil" <(E-Mail Removed)> wrote in message
>> > news:y4SWi.4015$(E-Mail Removed)...
>> >>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.
>> >
>> >
>> >
>> >
>> >
>>
>>
>>

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.


"Neil" wrote:

> 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?
>
>
> "boblarson" <(E-Mail Removed)> wrote in message
> news:39896405-A832-4E91-8DB5-(E-Mail Removed)...
> >>>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" wrote:
> >
> >> 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
> >>
> >>
> >> "Stuart McCall" <(E-Mail Removed)> wrote in message
> >> news:fggsol$nd3$1$(E-Mail Removed)...
> >> > "Neil" <(E-Mail Removed)> wrote in message
> >> > news:y4SWi.4015$(E-Mail Removed)...
> >> >>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" <(E-Mail Removed)> escribió en el mensaje
news:y4SWi.4015$(E-Mail Removed)...
>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.
>

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.

"boblarson" <(E-Mail Removed)> wrote in message
news:C95075BE-D60D-414D-876F-(E-Mail Removed)...
> 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.
>
>
> "Neil" wrote:
>
>> 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?
>>
>>
>> "boblarson" <(E-Mail Removed)> wrote in message
>> news:39896405-A832-4E91-8DB5-(E-Mail Removed)...
>> >>>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" wrote:
>> >
>> >> 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
>> >>
>> >>
>> >> "Stuart McCall" <(E-Mail Removed)> wrote in message
>> >> news:fggsol$nd3$1$(E-Mail Removed)...
>> >> > "Neil" <(E-Mail Removed)> wrote in message
>> >> > news:y4SWi.4015$(E-Mail Removed)...
>> >> >>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.
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>

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


"Stuart McCall" <(E-Mail Removed)> wrote in message
news:fggsol$nd3$1$(E-Mail Removed)...
> "Neil" <(E-Mail Removed)> wrote in message
> news:y4SWi.4015$(E-Mail Removed)...
>>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.
>
>
>
>
>