Access 2007 Runtime Reports

[gregoryagu]

I have two clients which are running two different Access 2007 database, both on the runtime.

It all works great with the exception of reports. It seems that sometimes access cannot find the report, and instead prints the screen as a screenshot.

I have searched on this issue, and I make very sure the correct object is selected before printing.

The only workaround that I have found for this is to omit the print preview, and send the report directly to the printer.

When I do the print preview, the preview looks fine but then I get a screenshot instead of the report.

Of course, on my machine it always works fine. I have not had this issue at all with Access 97, only once I started putting things into 2007 did this problem come up at it comes up regularly.

Any info would be appreciated.

Greg

 

[HiTechCoach]

I have never had this issue with 2007 and reports.

So you arr migrating from 97 to 2007. Have you work much with Access 2000, 2002, 2003, or 2007?

What VBA code are you using to print your report?

 

[giovaanni]

One of the versions probably has a toolbar that shouldn't be open. It's trying to print the form instead of the report.

 

[gregoryagu]

Thanks, got this resolved.

Greg

 

[HiTechCoach]

Glad to hear that you found a solution!