G
Guest
#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.
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.