Can't get report to print

[Guest]

I have a command button on a form "Print Case Report" that won't print
the report. It appears to go to the printer as I can see momenentarily the
little "printing pages 1-6", but then noting prints out. It will print if I
open it in print preview and right click on it and then click on print. I
don't understand this.

Another on of my reports prints just fine with the cmd button on the form. I
have the app deployed over Citrix and I get the message "You must install a
printer."

An aside, is it possible to embed a print command in the preview view's
report bar where the report caption shows up?


Any help is greatly appreciated. Here's the code behind the button. Thanks,
Rob


Private Sub cmdPrintCaseReport_Click()
On Error GoTo Err_cmdPrintCaseReport_Click

Dim stDocName As String

stDocName = "rptCaseReport"
DoCmd.OpenReport stDocName, acNormal


Exit_cmdPrintCaseReport_Click:
Exit Sub

Err_cmdPrintCaseReport_Click:
MsgBox Err.Description
Resume Exit_cmdPrintCaseReport_Click

End Sub

 

[Guest]

I'm reposting this in Reports. Still could use help, I'm desprate.

 

[Powderfinger]

Open up the report in design view. Select File/Page Setup from the main
menu. Click the Page tab and make sure the correct printer is selected.

 

[Guest]

Thanks for the reply. As I said in the post, it will print if I right click
on the report in preview view. It needs to go to the default printer. Any
other ideas,

Thanks Rob

 

[Powderfinger]

How did you get the report in Print Preview? Did you use the button or
through the database window.

I would change the DoCmd.OpenReport line to:

DoCmd.OpenReport stDocName, acViewPreview

To see if you can get it to open in print preview with that button.

If you have already done this , try changing the line to this:

DoCmd.OpenReport stDocName, acViewNormal

Just a hunch.

 

[Guest]

I've done all that as you can see from the original post. I can open it
preview and print it out using right click and selecting the print icon. It
just won't print using acViewNorma