copying access objects from file to file.

C

Chris

Hi,

I have an Access 2000 ADP with many forms, modules, class modules, and
reports.

I have another ADP with the same. I want to put the forms( with VBA code) of
one of these into the other file.

A simple copy and paste should work but when I copy and paste the form into
the other project and try to run the form, I get errors:

network connection has been lost.

I would guess this is a microsoft glitch.

how can I get my forms accompanying VBA code from one access file to another
without breaking it. Also the copy breaks all the original forms too.

thanks

Chris
 
E

Eric Blitzer

Go to the new database and use the File/Get Exterbal Data option from the
menu. This will bring a dialog box for you to choose the database to
import from. Then pick the tables/forms/queries... that you want to import.
 
K

Klatuu

Sorry Chris, not a Microsoft glitch, it is a Chris glitch :)
The correct way to do this is open the mdb where you want the object to be,
then
Use File->Get External Data from the menu, select the mdb where the objects
are. You will then be presented a dialog where you can select the objects
you want to import.
 
Top