Is it possible to import forms from another MSAccess database using VBA 
code?
eg: my application (MyApp.mdb) requires a form (frmMain) to be updated 
from a database called Patch.mdb.  frmMain exists in MyApp.mdb.  
When MyApp.mdb opens, I want it to delete frmMain and import frmMain from 
Patch.mdb. 

Or is there a smarter way to update a clients mdb than this?

Thanks
Alister

open the database that you want to import to:  click File, "get external
data",
choose the file name of the database you want to get the form from; click
the "Form"
tab, choose the form; and click ok.  Thats it.

later,
bware

-----Original Message-----
From: Alister Neave [mailto:ahneave@b...]
Sent: Saturday, November 30, 2002 9:36 AM
To: Access
Subject: [access] How do I Import Forms etc into a database


Is it possible to import forms from another MSAccess database using VBA
code?
eg: my application (MyApp.mdb) requires a form (frmMain) to be updated
from a database called Patch.mdb.  frmMain exists in MyApp.mdb.
When MyApp.mdb opens, I want it to delete frmMain and import frmMain from
Patch.mdb.

Or is there a smarter way to update a clients mdb than this?

Thanks
Alister

Hi Alister

If you want to do this in VB use the 'DoCmd.TransferDatabase' method.  You
can find it in the VB help files.

Regards, Wesley Kendrick

----- Original Message -----
From: "Alister Neave" <ahneave@b...>
To: "Access" <access@p...>
Sent: Saturday, November 30, 2002 9:36 AM
Subject: [access] How do I Import Forms etc into a database


> Is it possible to import forms from another MSAccess database using VBA
> code?
> eg: my application (MyApp.mdb) requires a form (frmMain) to be updated
> from a database called Patch.mdb.  frmMain exists in MyApp.mdb.
> When MyApp.mdb opens, I want it to delete frmMain and import frmMain from
> Patch.mdb.
>
> Or is there a smarter way to update a clients mdb than this?
>
> Thanks
> Alister
>