Output file field in Access report ?

Posted on 2013-08-27
Medium Priority
Last Modified: 2013-09-21

    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 ?
Question by:Vaibhavjoshi2005
  • 2
  • 2
LVL 21
ID: 39444365
Yes you can print image files on an Access report.

Author Comment

ID: 39444476
I can put image files in access report but can I retrieve images in a query and put it in report ?
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39445573
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

Author Comment

ID: 39466164
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.
LVL 74

Accepted Solution

Jeffrey Coachman earned 1000 total points
ID: 39466222
As far as I know this is not possible in a report
All that will show in the report is the PDF icon

If you could use a form and store the "Full File name" (instead of storing the file as an attachment), then this is tricky, but doable if you are very good at VBA.

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question