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!

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

Print report problem in access2k by codes.

Status
Not open for further replies.
softlover

softlover

Programmer
Apr 4, 2002
88
CN
I want to print a report to the printer directly.
but the following codes can't fit it.
Docmd.OpenReport "MyReportName", AcNormal
Anyone help me.
 
Sort by date Sort by votes
And this ?
Docmd.OpenReport "MyReportName", acViewNormal

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
I had try the codes,
Docmd.Openreport "MyReportName", AcViewNormal
and
Docmd.OpenReport "MyReportName", AcNormal
When these codes run, a popup window display the following message,
Currently printing the first page of "MyReportName"
on the LPT1: print to
hp laserjet 1130
But the printer hasn't any action.

If use the codes,
Docmd.Openreport "MyReportName", AcPreview
I can preview the report and print it by press the "PRINTER" button.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Concatenation problem 3
Replies
5
Views
1K
Moss100
Moss100
Moss100
  • Locked
  • Question
Filter vba problem
Replies
1
Views
736
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Using Report Header (Form control) as Variable in Report Expression 1
Replies
11
Views
1K
dhookom
dhookom
JimStrand
  • Locked
  • Question
Trying to Use Form Control as Variable in Report Control Source 2
Replies
5
Views
721
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
4K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top