Consulting

Results 1 to 2 of 2

Thread: Save report as .pdf

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Save report as .pdf

    Hello, I have a report that isn't open BUT I want to save it to my desktop as a .pdf from a button and delete one if it has the same date and replace it. The report pulls data off the form I'm on. Also, if it needs t be open to save is there a way to open it hidden.

    Dim strSViser As String
    strSViser = Me.cboSupervisorName.Column(1)
    DoCmd.OutputTo acOutputReport, "rpt_EmailDailyProduction", acFormatPDF, "C:\Users\" & Environ("username") & "\Desktop\" & Format(Date, "MM-dd-yyyy") & " " & strSViser & " Superlog.pdf"
    Thanks,
    Last edited by oxicottin; 10-14-2019 at 12:40 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •