I've got a 2010 accdb that print previews a report. Here's the code:

DoCmd.OpenReport "<report name>", acViewPreview


If I attempt to print this report from the preview, I get error 3035 "System Resources Exceeded". Sometimes I get a message that there isn't enough memory and I need to shut unnecessary programs down.

If I change the code like so:

DoCmd.OpenReport "<report name>"

then it prints just fine.

Any idea what's causing this message? I have similar reports that I can preview, then print from the preview, just fine.

Thanks for any help or advice.

I presume you can print other reports OK from preview. If not do a
"Detect and Repair" on office. If it is just that particular report
try exporting the report and any sub reports to another database then
delete the report(s), compact and repair the DB. Close the DB, start
the DB using the /decompile switch. Close the DB reopen, do a compact
and repair then import the report(s) and try running it again.

On Jul 1, 3:20*pm, emanning <emann... (AT) kumc (DOT) edu> wrote: