Prompt for Printer 1

[Damiankk]

I'm assuming this is a fairly simple problem for someone. I have a report called "Daily Sales Report" and all I want to do is print the report, but for it to prompt me which printer to select before printing. That's it. Here is what I have so far. Thanks for any help.

Private Sub Command24_Click()
DoCmd.OpenReport "Daily Sales Report", acViewNormal
End Sub

 

[RuralGuy]

This link should help:

http://www.mvps.org/access/reports/rpt0015.htm

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit

 

[Damiankk]

This brings up the Print Dialog Box but it prints out a screen shot of my form instead of the report.

 

[RuralGuy]

Hmmm...maybe this link is better:

http://allenbrowne.com/AppPrintMgt.html

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit

 

[PHV]

wHAT ABOUT THIS ,
DoCmd.OpenReport "Daily Sales Report", acViewPreview

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Damiankk]

PHV, your command is to preview a report not to print with a prompt for a printer.

Can you help with a prompt?

 

[JoeMicro]

how about

DoCmd.RunCommand acCmdPrint