Printing Attachments from Form onto Access Report

[thepharcyde]

Trying to suss this out.

I need to paste in screenshots into a DB that consistently will not be the same size etc thereby OLE Object type does not work as Access cannot ascertain the size to grow/shrink as an ordinary text field parameter/option.

As such I believe this can be achieved via attaching the screenshot via PDF/DOCX attachments to the form in question and then outputting these via a Report.

Thereby my form is made up of the following attachment field tags

Screenshot_Attachment1
Screenshot_Attachment2
Screenshot_Attachment3
Screenshot_Attachment4
Screenshot_Attachment5

Each of these will solely have a singular PDF/Word attached and called the same file name each time.

I need to create a report that under the relevant section it also prints the relevant PDF/Word Attachment applicable

e.g.
Screenshot_Attachment1
Screenshot1.pdf/docx

Screenshot_Attachment2
Screenshot2.pdf/docx

Screenshot_Attachment3
Screenshot3.pdf/docx

Screenshot_Attachment4
Screenshot4.pdf/docx

Screenshot_Attachment5
Screenshot5.pdf/docx

Do you know how I can achieve this that I believe would be via VBA code?

Can you assist in this regard.

 

[ranman256]

Pasting OLEimages does not matter about size...they can be different sizes.
Make an OLE field and paste the images into the fields.