#1       Today, 02:57 PM  
llkhoutx  
Registered User   Join Date: Feb 2001
Location: Houston,Texas USA
Posts: 2,607


Export a custom Toolbar

--------------------------------------------------------------------------------

I support 30 (non-techie, Access newbee) accountant database users and their
several hundred Access 2000 (non-compiled) mdb production databases.

I want to export (or "push") an identical (named) custom toolbar to each of
those mdbs and have it display when each of those databases are opened. I'm
already cycling through a list of the mdbs and their respective folder, using
the TransferDatabase method to transfer a macro and a function to each mdb. I
need to also transfer/export a toolbar which has a button to execute a new
function.

The "DoCmd.TransferDatabase acExport, . . ." doesn't include an option to
export toolbars.

Of course, I can manually navigate to and manually open each of thiose
databases and import the toolbar, but I'm lazy and have fat fingers which are
prone to typing errorz. I want to export the toolbar programmatically.

Does anyone have or seen a VBA or macro method for doing this.

Thank you in advance for your assistance, ideas and comments.