Results 1 to 7 of 7
  1. #1
    Vaporhead is offline Novice
    Windows 10 Office 365
    Join Date
    Feb 2024
    Posts
    13

    PDF Export Cutting off right side

    Hello.



    I have a report which is then exported in .pdf. While in "print preview" the report looks perfect, but when it is exported, the pdf is missing like an inch or so of the right side of the report. This has happened before but was fixed when I added the "acExportQualityPrint" to the end of the command. The problem has presented itself again. All margins are set and everything in my report falls within those margins.


    Here is my VBA for the export button:

    DoCmd.OutputTo acOutputReport, "qryFindingSPARReport", acFormatPDF, Environ$("USERPROFILE") & "\Documents" & Me.[Commissary_Location] & "_" & "Findings_Report" & ".pdf", False, "", acExportQualityPrint

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Can you test from another computer? What PDF printer driver do you have? Want to provide db for analysis? Follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Vaporhead is offline Novice
    Windows 10 Office 365
    Join Date
    Feb 2024
    Posts
    13
    I forgot to mention that the report looks very magnified while viewing the PDF export....

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,945
    That could just be the magnification setting in the pdf reader?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    Vaporhead is offline Novice
    Windows 10 Office 365
    Join Date
    Feb 2024
    Posts
    13
    Wish I could tell you what PDF printer driver I am using, but my computer is telling me that my "print spooler" is not running. My IT department tried to fix but they also can't get my printer spooler to run. I don't know if this has something to do with my issue, but maybe. Wish I could attach my database, but my agency rules prohibit that.

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,945
    Is the service running?
    Is it's dependencies?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  7. #7
    Vaporhead is offline Novice
    Windows 10 Office 365
    Join Date
    Feb 2024
    Posts
    13
    The spooler service is not running, and even after the IT technicians restarted the print spooler, it goes right back to not running. They had to escalate the trouble ticket.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 10-31-2019, 04:32 PM
  2. Replies: 3
    Last Post: 07-11-2019, 09:43 AM
  3. Replies: 6
    Last Post: 09-10-2017, 08:13 PM
  4. Replies: 11
    Last Post: 06-23-2017, 10:25 AM
  5. Replies: 2
    Last Post: 07-25-2016, 01:12 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
  •  
Other Forums: Microsoft Office Forums