Printing report with AutoExec macro

  • Thread starter Thread starter JerryC
  • Start date Start date
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.
 
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",
Click to expand...
acViewPreview, "PMQAutoPrintDues"
 
Back
Top