 | |
Does anyone understand toolbars?
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Search this Thread | Display Modes |
#11
 
| |||
| |||
|
Re: Does anyone understand toolbars? -
11-12-2007
, 05:53 AM
|
.WizCopyCmdbars "CommandBarsHolder.mdb" I get the error: "Object doesn't support this property or method." |
--
lyle fairfield
#12
| |||
| |||
|
|
On Sat, 10 Nov 2007 22:20:24 GMT, "Neil" <nospam (AT) nospam (DOT) net> wrote: Rather than making a copy of your database I would try creating a new blank database and import only the toolbars from your database and no other objects. So you now have a database containing nothing but toolbars. Delete the toolbars you don't want, rename your target TB. Edit the TB as required and then import it back to your database. This might break whatever link is syncing the toolbars in the background. Don't know if it will work but it would be worth a try. No, that's exactly what I did -- except I didn't delete unused objects. I simply made a copy of the MDB, renamed the toolbar, and then imported all toolbars. Since the other toolbars had the same name as their original counterparts, they didn't import. The only thing that imported was the one that I renamed in the copy. So, I thought everything was fine, as I had two toolbars with two different names -- one for one form, and one for another form. The problem arose when I started modifying the copy. When I modified the copy that I had imported, the original was modified as well. Two toolbars in the database, two different names; yet somehow Access sees them as the same toolbar. "Arvin Meyer [MVP]" <a@m.com> wrote in message news:uFdZ7L6IIHA.4808 (AT) TK2MSFTNGP05 (DOT) phx.gbl... Can you not make a copy of the database. Delete all the unused objects in the copy and use that as a basis for your new database? You should be able to rename and alter the copy in that manner. Doing whatever you wish to the "new" toolbar, then import the objects from the old database, including the old toolbar. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Neil" <nospam (AT) nospam (DOT) net> wrote in message news:frhZi.4926$yV6.4292 (AT) newssvr25 (DOT) news.prodigy.net... So, I tried to copy a toolbar. I have a custom menu bar for a form. Tried to copy it so that I could modify the copy and use it with another form. With no direct way to copy it, I made a copy of the MDB, renamed the toolbar, and then imported it back into the original MDB as a copy of the original (see "Copying a custom menu bar" thread here). Everything seemed fine until I tried to modify the copy. When I added or removed items from the menu bar, the original was modified as well! They were one toolbar with two instances in the db. So I'm back to where I started. Anyone know of a way to make a copy of a toolbar so that I can modify it and use a slightly different version with another form? Wayne Gillespie Gosford NSW Australia |
#13
| |||
| |||
|
|
"Neil" <nospam (AT) nospam (DOT) net> wrote in news:gHTZi.68231$YL5.49285 (AT) newssvr29 (DOT) news.prodigy.net: .WizCopyCmdbars "CommandBarsHolder.mdb" I get the error: "Object doesn't support this property or method." You're using Access 2000, I think. -- lyle fairfield |
#14
| |||
| |||
|
|
On Sat, 10 Nov 2007 22:20:24 GMT, "Neil" <nospam (AT) nospam (DOT) net> wrote: Rather than making a copy of your database I would try creating a new blank database and import only the toolbars from your database and no other objects. So you now have a database containing nothing but toolbars. Delete the toolbars you don't want, rename your target TB. Edit the TB as required and then import it back to your database. This might break whatever link is syncing the toolbars in the background. Don't know if it will work but it would be worth a try. |
blank db, imported the toolbars from the original db into it; deleted
unneeded objects; renamed the remaining custom menu bar; modified the menu
bar. I then deleted the original toolbar from the original db, compacted the
db, and then reimported that single menu bar back into the original db. And
guess what? It still paired up with its twin! That's right -- the
modification I made to the toolbar in the blank db was brought back into
original db in both that toolbar and in the original toolbar. The two are
inseparable.
To recap: toolbar "A" was copied to toolbar "B". Modifications made to one
were reflected in the other. Importing A and B into new B and deleting A
from new db and deleting B from original db was thought to possibly break
the link. Toolbar B was modified and renamed and brought back into original
db, and modifications were reflected in A! Talk about inseparable!
There seem to be no options here except to rebuild B from scratch. Sigh.
Anyway, thought you'd find that interesting.
Neil
|
« Previous Thread
|
Next Thread »
| Thread Tools | Search this Thread |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.