How to copy form from 1 database to another programatically

[MisterDan]

Hi, my Access database somehow got corrupted. It won't open, and it won't repair using the repair tool. However, I've been able to copy data from the tables in the corrupted database to another (non-corrupted) database using VBA, and I'm hoping to be able to copy the forms and reports. But, I've never done that. How do you copy a form/report from one database to another using VBA?

Thanks. Dan

 

[barny2006]

can you share that code with us? i have applications that calls for importing/exporting tables from one db to another?
thanks!

 

[fneily]

Have you looked at the TransferDatabase method of the DoCmd object? You can import/export tables, forms, report, macros with it. Also, you can use the TransferDatabase method in a macro. In VBA, just type in DoCmd.TransferDatabase, select TransferDatabase and hit F1. It'll explain the parameters.