Link to home
Start Free TrialLog in
Avatar of BFanguy
BFanguyFlag for United States of America

asked on

Microsoft Access including files as incorporated parts of a report (i.e. embedded in the report itself)

Is there a way to combine pdf / jpg / doc files into an access report?

I have records that point to a file or a folder on a server, they can be many different file types that when a user prints a report, i would like to print the files the records points to as well.

using access 2010 currently
Avatar of als315
als315
Flag of Russian Federation image

Look at my article Images on continuous forms. You can use this technique in reports also
Avatar of BFanguy

ASKER

Thanks, will give this a try using a report.
Avatar of BFanguy

ASKER

One other thing, my link may point to a folder that has multiple documents in it that all need to be printed along with the report.  
Any ideas on this conundrum?
Avatar of BFanguy

ASKER

Tried creating a report using your sample db and i can't get the image to display.

also note you have to use an accdb (2007-2010) database for your example to work.
Avatar of BFanguy

ASKER

als315, i can't get this to work with pdf files.  any ideas?
Can you upload sample and some sample images? This approach working with all access versions from 2007
Avatar of BFanguy

ASKER

i used your example and copied in a pdf and changed your 3 record to point to the pdf and it does not display the pdf.

took your example and tried creating a report using the same logic, pdf's don't show.
PDF is not an image file. Image control can show only images. You can try to use web control, but it couldn't be used in continuous forms. May be you can convert your files to images?
I don't know way to attach any file to report and show it.
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BFanguy

ASKER

Thanks, i am thinking that i am going to have to print each section of the reports to separate pdf files and open each attachment and print pdf files and then use adobe api to combine all the files into one pdf.