none
Access Web App: How to extract images into the report? RRS feed

  • Question

  • Hi,

    I have an access web app which contains a variety of fields including text, dates and images and I wish to generate auto reports within access. I have brought in all of the fields I want displayed in the report but unfortunately, when the report is created, it does not display images. Is there a way to have the images display in reports or is this just not an option in the web app? All of the other fields display their information correctly.

    Cheers,

    Nathan

    Wednesday, November 11, 2015 5:21 AM

Answers

  • Hi Nathan,

    I made a test with your description, and I could reproduce your issue.

    As my test, I found that the image file are stored as ole Object in Access database. It is a known issue from the link below:

    # Images that are stored in OLE object fields do not appear correctly
    https://support.microsoft.com/en-us/kb/832508

    For workaround1, I tried to find Microsoft Photo Editor for later system version, but I failed.

    For workaround2, we will need to convert the ole object value to image file in a folder and then display the images from a folder. With Access object model, there is no directly way to achieve this, and for the converting issue, I suggest you go to the forum below for help.

    #Reference: http://social.msdn.microsoft.com/Forums/en-US/home?forum=isvvba

    You could refer the link below for displaying images from a folder.
    # How to display images from a folder in a form, a report, or a data access page
    https://support.microsoft.com/en-us/kb/285820

    In addition, for this issue, I suggest you submit a feedback in the link below:
    #Reference: http://access.uservoice.com/

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Friday, November 13, 2015 7:52 AM