Combining applications

[bestbapu]

I have three applications that have a combination of linked and unique tables.

I want to merge all forms, reports, libraries, functions and procedures into
one application and redesign all tables in this single new application.

My thought is to start a new .mdb. Create all tables. Export andd import all
data from 'older' tables. Copy over all forms, reports etc. and make
corrections to column names and/or functionality.

How do I get an object (i.e. a form or report or...???...) from on
application into another?

TIA for any help,

 

[GeoffG]

I think this might be best done manually as follows:

1. In a new blank database, open the File menu, select Get External Data,
then select Import.

2. In the Import dialog, point to one of the three databases, and click the
Import button.

3. The Import Objects dialog opens, which allows you to select the objects
you want.

4. Repeat for the other two databases.

Regards
Geoff

 

[bestbapu]

Thanks Geoff. This should help considerably.

I think this might be best done manually as follows:

1. In a new blank database, open the File menu, select Get External Data,
then select Import.

2. In the Import dialog, point to one of the three databases, and click the
Import button.

3. The Import Objects dialog opens, which allows you to select the objects
you want.

4. Repeat for the other two databases.

Regards
Geoff