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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't print Access 2003 report

Status
Not open for further replies.

kimsMTC

Programmer
May 30, 2007
50
US
I have an Access 2003 application that has a PRINT button. The clicked event code is:

strReport = "Preview Timesheet"
DoCmd.OpenReport strReport, acViewPreview

DoCmd.PrintOut

DoCmd.Close acReport, "Preview Timesheet", acSaveNo

This works for me, but when my client runs it, it pops a SAVE AS dialog box for a document imaging document. What do I need to change? TY
 
The client has a default printer set that works for all her other applications. That's what I don't understand.
 
Anyway, why not simply this ?
DoCmd.OpenReport "Preview Timesheet", acViewNormal

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Thank you! I did not realize that the default for OPENREPORT was to auto print. I will try and see if this works.

TY
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top