Results 1 to 11 of 11
  1. #1
    cuddles is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    98

    Export Report to PDF

    I have a bitmap at the top of my report page and when I send the report to the printer, the bitmap prints out just fine, but if I save as a pdf, the bitmap does not show up at the top of the first page. I have the bitmap in the header. I cannot seem to find a way in my docmd to make sure the bitmap shows up on that top page.

    Here is my code:



    Code:
    Private Sub pdf_Click()
    DoCmd.OutputTo acOutputReport, "ReportQ1", acFormatPDF, myReportOutput, , , , acExportQualityPrint
    End Sub

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Does the BMP appear in print preview?

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    That is correct and it works for me.
    But make sure the property of your image (format tab) has DISPLAY WHEN = always.

  4. #4
    cuddles is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    98
    Yes it appears in the print preview and yes I have display when = always. I am exporting to PDF to save and that is when it does not appear. I just tested it on all my reports and it is our logo they want on PDFs

  5. #5
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I just used the wizard to create a logo in the Report Header and I also created an "Insert Picture" in the Report Header. I used your code behind a button and it worked for me, both times. I even made sure I used BMP as a source.

  6. #6
    cuddles is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    98
    Then it must be something to do with the save as a PDF option. The code I have behind it is:

    Code:
    Private Sub PDF_Click()
    DoCmd.OutputTo acOutputReport, "ReportQ1", acFormatPDF, myReportOutput, , , , acExportQualityPrint
    End Sub

  7. #7
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Quote Originally Posted by ItsMe View Post
    I just used the wizard to create a logo in the Report Header and I also created an "Insert Picture" in the Report Header. I used your code behind a button and it worked for me, both times. I even made sure I used BMP as a source.
    ...........

  8. #8
    cuddles is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    98
    Ok, well it is not working for me. I even redid it. So, there is either something wrong with the PDF code or maybe my version of Adobe does not support it. If that is the case then no one in the org if they save as PDF will ever see our logo.

  9. #9
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Quote Originally Posted by cuddles View Post
    ... I even redid it...
    If "redoing it" means you are unable to duplicate what I did on my machine, using my tables, using my reports then, yes, I would guess there is a problem with the adobe dll's/printer drivers.

    I suggest isolating your DB and working on another DB with test data.... like I did to test your code.

  10. #10
    cuddles is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    98
    I found the issue. The picture was not named bmp. It was named png. So, it was not working. It works now. Thanks

  11. #11
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Glad to hear you were able to resolve the issue

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

Similar Threads

  1. export report
    By slimjen in forum Forms
    Replies: 7
    Last Post: 04-24-2013, 08:14 AM
  2. Automatically export report as PDF
    By napsterxp in forum Reports
    Replies: 1
    Last Post: 04-08-2013, 04:42 PM
  3. Report Export to Excel
    By BLD21 in forum Import/Export Data
    Replies: 1
    Last Post: 05-06-2011, 10:19 AM
  4. Export report to jpg
    By isdm in forum Reports
    Replies: 1
    Last Post: 04-16-2010, 10:00 PM
  5. Export of Relationships Report
    By bar tomas in forum Reports
    Replies: 1
    Last Post: 04-09-2009, 09:03 AM

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