Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Prompt for Printer 1

Status
Not open for further replies.

Damiankk

Technical User
Nov 25, 2008
10
US
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
 
This brings up the Print Dialog Box but it prints out a screen shot of my form instead of the report.
 
wHAT ABOUT THIS ,
DoCmd.OpenReport "Daily Sales Report", acViewPreview

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
PHV, your command is to preview a report not to print with a prompt for a printer.

Can you help with a prompt?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top