By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,704 Members | 1,396 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,704 IT Pros & Developers. It's quick & easy.

Report print problem

P: 66
I have various print buttons that allow the database users to print reports, the database has been created so none of the normal access background is showing, just the form.

currently when the user click the 'print' function it prints the report without showing the 'print proerties' dialog box. is there any thing i can do about this, so the 'print properties' box is shown?

here is the sample of my print code:
__________________________________________________ _______
On Error GoTo Err_cmdATMOLine1_Click

Dim stDocName As String

stDocName = "ATMO Line 1 - Open Tasks"
DoCmd.OpenReport stDocName, acNormal

Exit_cmdATMOLine1_Click:
Exit Sub

Err_cmdATMOLine1_Click:
MsgBox Err.Description
Resume Exit_cmdATMOLine1_Click
__________________________________________________ _________
Apr 3 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Try changing this line ...

Expand|Select|Wrap|Line Numbers
  1.  
  2. DoCmd.OpenReport stDocName, acNormal
to this ...

Expand|Select|Wrap|Line Numbers
  1.  
  2. DoCmd.OpenReport stDocName, acViewPreview
Mary
Apr 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.