Link to home
Start Free TrialLog in
Avatar of Vaibhavjoshi2005
Vaibhavjoshi2005

asked on

Output file field in Access report ?

Hi,

    I have a file field in MS -access where I want to upload PDF or JPG image of a document. Is it possible to output this image in a access report ?
Avatar of Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Flag of United States of America image

Yes you can print image files on an Access report.
Avatar of Vaibhavjoshi2005
Vaibhavjoshi2005

ASKER

I can put image files in access report but can I retrieve images in a query and put it in report ?
Lets slow down...
Have you already loaded the file into the field? Yes or No?
(If not, is this the focus of your question)

If so, then what is the datatype of this field?
OLE?, Attachment?, a link path, BLOB ?

What do you mean by "retrieve images in a query"?
You can create a query with the fields you need, then make a report from it.

What exactly will you be uploding to this field, PDF's or Jpg images, ...or both?

If you are uploading PDF files, I don't know of anyway to display them directly in a report.
The last time I tried this with a PDF viewer control the results were not consistent.   But things may be different now...

If you are loading jpg images to an attachment field, then yes, they will be viewable in the Report (or form)

I have had mixed results with OLE datatypes, but again, this may have changed.

If you are storing the Path to the image (and not the file itself, you can display the image in a Report with something like the attached file.

If you are storing the path to a PDF, then I have found no way to display it in a Report. You can however display it in a Form using the WebBrowser control...

So as you can see you need to very clear hear on what you will be doing and why...

Hope this helps
;-)
JeffCoachman
Access-BasicLinkOpenFileDialogBo.mdb
I plan to load PDF document in the attachment field. The pdf maybe purely text or text + image or only image, but it will always be stored as PDF.

Now I want to output this PDF in the report.
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America 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