Picture Not Displaying in a Report

[KLA]

I am trying to create a report displaying pictures using the Bound
Object Frame in MS Access 2003 and I cannot get them to display. I
have checked postings on this topics trying a few things and looked to
see how it was done in the NorthWind sample database and cannot get it
to work. I AM COMPLETELY STUMPED!!!!

The pictures are .jpg files stored on a shared drive.

Does anyone have any tips?

Any assistance would be very much appreciated.

Kyle

 

[strive4peace]

Hi Kyle

If you are storing the path and filename in a text field,
use an image frame (mountains and sun)

this goes in the OnPrint event of the section your image
control is in:

'~~~~~~~~~~~~~~~

Private Sub Detail_Print(Cancel As Integer, PrintCount As
Integer)

With FileImage_controlname
If Dir(nz(Me.filePathAndName_controlname),"") <> "" Then
.Visible = True
.Picture = Me.filePathAndName_controlname
Else
.Visible = False
End If
End With

End Sub
'~~~~~~~~~~~~~~~

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

 

[Larry Linson]

I am trying to create a report displaying
pictures using the Bound Object Frame
in MS Access 2003 and I cannot get
them to display. I have checked postings
on this topics trying a few things and looked
to see how it was done in the NorthWind
sample database and cannot get it to work.
I AM COMPLETELY STUMPED!!!!

The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. Two of the
approaches do not use OLE Objects and, thus, avoid the database bloat, and
some other problems, associated with images in OLE Objects. Two additional
useful approaches are not included in the sample: linking an image file to
an Unbound Object Frame, or using a hyperlink to display an image.

If you are printing the images in reports, to avoid memory leakage, you
should also see MVP Stephen Lebans' http://www.lebans.com/printfailures.htm.
PrintFailure.zip is an Access97 MDB containing a report that fails during
the Access formatting process prior to being spooled to the Printer Driver.
This MDB also contains code showing how to convert the contents of the Image
control to a Bitmap file prior to printing. This helps alleviate the "Out of
Memory" error that can popup when printing image intensive reports.

Larry Linson
Microsoft Access MVP