Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Copying/Editing a Toolbar in Access


Message #1 by amy.bender@p... on Wed, 22 Jan 2003 18:16:23
I'm doing some work for someone and the previously created database I'm 
working on has a special toolbar.  

The previous programmer put in code for the form's OnCurrent event to show 
or hide certain menu items.  Unfortunately this programmer didn't document 
very well.

How can I show all of the toolbar's items?  (When I start up the database 
certain items are already hidden and I only see them when going to certain 
records on the main form)

Or can I copy the toolbar from the old copy of the database to the newer 
one?

(I mistakenly deleted on toolbar item and it's messed the toolbar up and 
without documentation, it's makig it difficult to reset back. Ack!!)

Thanks!!

Amy

Motto for the day: Check, check, and re-check before editing. :-)
Message #2 by "zak willis" <zak@z...> on Tue, 28 Jan 2003 14:58:27
> I'm doing some work for someone and the previously created database I'm 
w> orking on has a special toolbar.  

> The previous programmer put in code for the form's OnCurrent event to 
show 
o> r hide certain menu items.  Unfortunately this programmer didn't 
document 
v> ery well.

> How can I show all of the toolbar's items?  (When I start up the 
database 
c> ertain items are already hidden and I only see them when going to 
certain 
r> ecords on the main form)

> Or can I copy the toolbar from the old copy of the database to the newer 
o> ne?

> (I mistakenly deleted on toolbar item and it's messed the toolbar up and 
w> ithout documentation, it's making it difficult to reset back. Ack!!)

> Thanks!!

> Amy

> Motto for the day: Check, check, and re-check before editing. :-)

You could put into the form load event / form current event something like 
application.commandbars("&File").enable or 
application.commandbars("&File").visible etc. I doubt the person would 
have disabled them. There is a lot of documentation on VBA commandbars. 
You can also set menu actions to fire functions, subs and macros. However, 
if it is an MDE file, then basically, you are stuffed. If you do a search 
on the internet for j-walk commandbars then you should find a very useful 
bit of excel code that can be modified for Access.
Regards,
Zak

  Return to Index