Printing report with AutoExec macro

J

JerryC

I am trying to print a report when the application start
up using the AutoExec macro.
The following line gives a Action Failed error, but the
report prints OK anyway.

DoCmd.OpenReport "PMR1", acViewNormal, "PMQAutoPrintDues"

If I change line to acViewPreview:

DoCmd.OpenReport "PMR1", acViewPreview, "PMQAutoPrintDues"

then I don't get the Action Failed Error.
I suspect it has something to do with default printer.
Any ideas would be helpful.
 
J

JerryC

After spending 1/2 day on this I discovered the error was
caused by the report Close event.
Thanks anyway if you were working on this.
-----Original Message-----
I am trying to print a report when the application start
up using the AutoExec macro.
The following line gives a Action Failed error, but the
report prints OK anyway.

DoCmd.OpenReport "PMR1", acViewNormal, "PMQAutoPrintDues"

If I change line to acViewPreview:

DoCmd.OpenReport "PMR1",
acViewPreview, "PMQAutoPrintDues"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top