Hello,
I have created a Crystal Report (v8.5) that will be accessed by end users through Microsoft Access (2000). The end users need the means to: 1) preview, 2) print, and 3) save to a file. I've included the ActiveX control for Crystal (Crystl32.ocx) and included the code for them to do the functions mentioned above.
The problem is that I want them to be able to choose a printer when they print instead of the report always going to their default printer. I found the method for
in the Crystal developr.hlp file, but if they press "Cancel" in the choose printer dialog box, the report still prints to their default printer.
Does anyone know how I can capture the "Cancel" event in this instance? I thought some sort of if/then statement like the following might work:
but everything I've tried so far is to no avail.
Please help... Thanks!
Lynn
I have created a Crystal Report (v8.5) that will be accessed by end users through Microsoft Access (2000). The end users need the means to: 1) preview, 2) print, and 3) save to a file. I've included the ActiveX control for Crystal (Crystl32.ocx) and included the code for them to do the functions mentioned above.
The problem is that I want them to be able to choose a printer when they print instead of the report always going to their default printer. I found the method for
Code:
.PrinterSelectDoes anyone know how I can capture the "Cancel" event in this instance? I thought some sort of if/then statement like the following might work:
Code:
With CrystalReport1
If .PrinterSelect <> "Cancel" Then
.PrintReport
End If
End WithPlease help... Thanks!
Lynn