Transferring Reports from another mdb

[JimP]

I have a table with a list of several hundred reports that I want to import
from another mdb that has say, 1,000 reports. I'm using
DoCmd.TransferDatabase, acImport,.....

I have a procedure that loops through the table importing each report -
however a window opens displaying the code module for each report.

Is there a way to suppress the code module window from opening, or to close
it as it imports each report?

 

[fredg]

I have a table with a list of several hundred reports that I want to import
from another mdb that has say, 1,000 reports. I'm using
DoCmd.TransferDatabase, acImport,.....

I have a procedure that loops through the table importing each report -
however a window opens displaying the code module for each report.

Is there a way to suppress the code module window from opening, or to close
it as it imports each report?

This is a one time thing?

Open your Database. Click on
File + Get External Data + Import
Navigate to the database that has the table and reports you wish to
import.
Select the table. Click on Options.
Select Definition and Data.
Click on the Report tab.
Select the reports you wish to import.
Click OK.
Done.