Show all attatchments in report

[white2golf]

I haver an employee database that has an attatchment field with up to ten picture attatchments per record. I would like to be able to generate a report that displays the name, job title and all pictures on one page for each employee like in the diagram below.




Title of report
Name & Job title

pic1 pic2 pic3 pic4 pic5

pic6 pic7 pic8 pic9 pic10

[June7]

Won't be able to display images across page like that unless you put each image in its own field.

Saving images within db will bloat the file. Access has 2gb size limit. Images can use up that limit quite fast. Review https://www.accessforums.net/access/...res-22388.html

http://answers.microsoft.com/en-us/office/forum/office_2007-access/access-2007-printing-attachments/26240df9-fbfe-42da-b220-5ab0d74ea370

[white2golf]

Since I am not able to display across is there a way I can generate a query or report that would pull these picture files in from a folder on the computer for each employee? We had a database previously that did this but the file on the old computer was destroyed and I have no way of remembering how the coding was set up for that. I have enclosed a scan of what the page looked like when we printed it out.

[June7]

Can use VBA code to programmatically manage dynamic display of images.

This article describes how dynamic image display was handled prior to A2007
http://office.microsoft.com/en-us/ac...spimgwinorform

Access 2007 introduced the ControlSource property to the Image Control.
http://bytes.com/topic/access/answer...-access-2007-a
You can either bind the ControlSource to attachment field with single file (compatible image type) or a text field that has the image path or use VBA code to set ControlSource.

Review http://allenbrowne.com/Access2007.html#Good