H
Help with Multi Catalog
I have discovered that this fails:
private sub DoListAndReceipt()
DoCmd.OpenReport ...
DoCmd.OpenReport ...
end sub
when my Printer is Offline.
The first OpenReport executes and makes it to the Printer Queue.
The second OpenReport does not execute at all.
Execution falls-thru to the "end sub".
Cancelling the first report in the queue does no good.
I have traced, trapped, etc., but to no avail.
The printer offline aborts the second DoCmd.OpenReport.
The application is in Access 2003 with a 2000 mdb format.
Does anyone have a "solid" means of retrieving the Printer Offline status
-or-
How the second DoCmd.OpenReport can be executed, despite Printer Offline (at
least the Report will be in the queue)?
private sub DoListAndReceipt()
DoCmd.OpenReport ...
DoCmd.OpenReport ...
end sub
when my Printer is Offline.
The first OpenReport executes and makes it to the Printer Queue.
The second OpenReport does not execute at all.
Execution falls-thru to the "end sub".
Cancelling the first report in the queue does no good.
I have traced, trapped, etc., but to no avail.
The printer offline aborts the second DoCmd.OpenReport.
The application is in Access 2003 with a 2000 mdb format.
Does anyone have a "solid" means of retrieving the Printer Offline status
-or-
How the second DoCmd.OpenReport can be executed, despite Printer Offline (at
least the Report will be in the queue)?