Is it possible to print linked photos in Access reports? 1

[AirPro]

My database includes linked photos in a form which works perfectly as you go from one record to the next and it selects the photo based on the [photo_id] field in the form and some code in the On Current Event property of the form (as suggested by DougP). I would like to print these linked photos in a report. Microsoft suggested specifying the file address using the ControlSource property of the Image Control. The problem is that Image Controls don't include this property. Any suggestions?

 

[Francescina]

I never managed to print my graphic files with this system. Since I use the Graphic Adminstration Wizard GAW-2000 (found it on SWREG.org) it works perfectly:

1.) Graphic files are embedded in the MDB without bloating!!
2.) you do not need to save long path/file names
3.) Graphic files are protected against deleting, copying, moving
4.) there is a thumbnail and Zoom function.
5.) unlimited number of graphics per record.

 

[AirPro]

Here's the answer:

Insert the same basis code used in the on_current event property of the form into the on_format event property of the report detail section. Here's an example:

Private Sub Detail1_Format(Cancel As Integer, FormatCount As Integer)
Me!Image107.Picture = "F:\DIVISION\AQD\Photos\" & Me![PHOTO_ID] & ".JPG"
End Sub

Make sure the image id [PHOTO_ID] is included in the report even if set to invisible.