Adding photos to reports

S

Sera

I am fairly new to access, and our work computers only have Access 2000
I have created a bi-Monthly report that we submit to a local La
Enforcement agency, from information we store here. They have aske
that we include photos in our report now. Is this possible? We have th
photos, but as of now, we have never linked them to the info, we onl
print them as needed
 
N

NthDegree

Yes, you can.

1. Add an Image control from your tool bar to the detail section of the
report (I'm assuming one detail record per photo). Make sure your your image
control and detail section is tall and wide enough to hold the pictures.
2. Right click on the Detail header in the report and left click on Build
Event.
3. Insert the following type of code in the Detail_Format Sub:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

Dim imgPictureName as String

'Some kind of look up code where you associate a picture file name to a
data record.
'Name of the image control is Image12

imgPicturename = (Name of picture file including drive,folder,filename)
Me!Image12.Picture = imgPicturename
End Sub
 
Top