print report in pdf format

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sedefy
    New Member
    • Sep 2010
    • 16

    #1

    print report in pdf format

    i have MS Access DB which generate a report
    i need to write a command line to be run under button click
    to print this report to pdf format each pdf output file contains one record an the name of each report will be equal to the id of that record
    note that each record is printed in 3 pages
  • tuxalot
    New Member
    • Feb 2009
    • 200

    #2
    try this out:

    Code:
     DoCmd.OutputTo acOutputReport, "report name here", acFormatPDF, MyFilename, False, , , _
                                           acExportQualityPrint

    Comment

    Working...