Print only one page of an ACCESS 2003 report

How do I print just the first page of an ACCESS 2003 report in VBA?

Sandra
ssmith94015Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
omgangConnect With a Mentor IT ManagerCommented:
Public Sub PrintReport()
On Error GoTo Err_PrintReport

    DoCmd.OpenReport "MyReport", acViewPreview
        'print the report - specify page from and page to
    DoCmd.PrintOut acPages, 1, 1

Exit_PrintReport:
    Exit Sub

Err_PrintReport:
    MsgBox Err.Number & " (" & Err.Description & ") in procedure PrintReport of Module Module9"
    Resume Exit_PrintReport

End Sub


OM Gang
0
 
ssmith94015Author Commented:
Thank you, this worked perfectly.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.