Solved

Print only one page of an ACCESS 2003 report

Posted on 2013-02-04
3
607 Views
Last Modified: 2013-02-04
How do I print just the first page of an ACCESS 2003 report in VBA?

Sandra
0
Comment
Question by:ssmith94015
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 30

Expert Comment

by:IanTh
ID: 38851814
0
 
LVL 28

Accepted Solution

by:
omgang earned 500 total points
ID: 38851816
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
 

Author Closing Comment

by:ssmith94015
ID: 38852565
Thank you, this worked perfectly.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS Access query 16 61
ODBC failure when running MSACCESS query a second time. 5 56
Cant delete records in query 8 49
MS Access vba Print  PDF First page only 16 34
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question