Problem Importing Reports into MS-Access 2007

[JimP]

The code behind a number of reports appears to be cross-linked. I've tried
decompile/compact/compile/compact on the source mdb without success.

Here's the situation,

1. Doing a typical report import from the menu errors out when it hits the
problem reports
2. I need to go to the source mdb, open the code behind the problem reports
and re-compile the code individually
2. Then I have a reports list and a loop to "DoCmd.TransferDatabase
acImport..."
3. When executing the code for a problem report, the VBA window tiles with
names for a number of reports - when a non-problem report has no tiling
4. It does import the report, but I'm afraid that there's still a potential
problem if I need to import the report again (would like to know what's
going on)

 

[Allen Browne]

If a compact, decompile, compact (using the old version) doesn't fix it, you
might try this:

1. Backup the database.

2. In the old version, open the problem report(s) in design view.
Open the code window.
Copy the code to clipboard, paste into Notepad, and save as a text file.
Close the code window.

3. Set the report's HasModule property to No.
Confirm the dialog that you really do want to lose the report's code.
Save and close the report.

4. Compact again.

5. Close that version, and open A2007.
Import the report.
Open the code window.
Paste in the code you saved at step 2.

 

[JimP]

Thanks, I'll give it a try.

If a compact, decompile, compact (using the old version) doesn't fix it,
you might try this:

1. Backup the database.

2. In the old version, open the problem report(s) in design view.
Open the code window.
Copy the code to clipboard, paste into Notepad, and save as a text file.
Close the code window.

3. Set the report's HasModule property to No.
Confirm the dialog that you really do want to lose the report's code.
Save and close the report.

4. Compact again.

5. Close that version, and open A2007.
Import the report.
Open the code window.
Paste in the code you saved at step 2.