PDA

View Full Version : Open Report action was canceled



Movian
09-28-2010, 06:57 AM
Hey,
we have a computer that is unable to open a report that up till now has been fine.

When you click the button to open the report you are presented with Run-Time error 2501 The OpenReport action was canceled

When atempting to open the report manually. It opens correctly in normal view however when attempting to change to a print preview the message shown is


"There was a problem retrieving printer information for this object. The object may have been sent to a printer that is unavailable"

Is it possible the printer driver is preventing the report from opening correctly ?

hansup
09-28-2010, 09:08 AM
"There was a problem retrieving printer information for this object. The object may have been sent to a printer that is unavailable" When the report opens, you can check its printer destination.
Private Sub Report_Open(Cancel As Integer)
MsgBox Me.Printer.DeviceName
End Sub Is that printer available? I suspect the error message is telling you it's not.

Movian
09-28-2010, 02:41 PM
The printer is installed and available according to the windows 7 device / printer panel