how do I export the code of a report in Access to another access d

[Netty]

I built a report in one access database and need to transfer the code of that
report to another access database that uses the same tables/queries. I don't
want to have to recreate the report in the second database. Is there a way to
copy the code/script of the report details into the other database?

 

[Ken Snell [MVP]]

You just want the code that is in the report's module? Open the report in
design view, go to the module, hit Ctrl+a to highlight all code, hit Ctrl+c
to copy it.

Then go to other database, open the report in design view, go to the module,
and hit Ctrl+v to paste the code. You will then need to go back to the
design view and "create" the event procedure setup for each event on each
control where you have corresponding code.

Alternatively, why not import the original report into your new database
(File | Get External Data | Import), and then you can delete the original
report in the second database and rename the imported one to that original
report's name.