Pictures do not appear in preview

[Golf beats work]

In preview I am unable to see the linked images - all i can see is the text
describing the name of the the file

I have tried embedding and linking to images but neither way works

I can see the images in the database by dbl clicking the field

Any help gratefully recieved

 

[Larry Linson]

In preview I am unable to see the linked images -
all i can see is the text describing the name of the the file

You haven't even begun to provide enough information about what you have and
how you are trying to do these things for anyone to hazard a guess about how
to help. But, see below for some general information on pictures and
displaying them in Forms and Reports.

I have tried embedding and linking to images but
neither way works

I can see the images in the database by dbl clicking
the field

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.

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.

And, Stephen has an ActiveX control available that works in cases where the
graphics filters are not available -- and works better, I've heard, than the
OLE Object and OLE Controls.

Please note that there are other approaches, e.g.,
Application.FollowHyperlink, but those, like OLE and Bound OLE Frames still
leave
you "at the mercy of the imaging software registered for the filetype".

Finally, Access 2007 has enhancements that, reputedly, eliminate the
database bloat long associated with OLE Objects and Bound OLE Frames. But,
it still leaves you relying on the software registered for the image type,
which may not be as "cooperative" as we'd like in creating our display. It
also has the capability of having a variable number of Attachments to a
Record, which may be helpful. But, as I have not done much with it yet, I
certainly wouldn't suggest you rush out and replace an earlier version --
until you have a copy incorporating, at least, the first Service Pack, or
have
the SP in hand and ready to apply as soon as you install Access 2007.

Larry Linson
Microsoft Office Access MVP

 

[Golf beats work]

Thanks for your reply Larry - My apologies for the brief explanation - What I
should have said is that this is my first attempt at using images in reports
although I have used access for some years to produce reports. When I am in
report design mode I have dragged the field containing the image onto the
report, sized and positioned it but when I hit the preview I get all of the
text and maths data I need but the images appears as a blank box with the
name of image but no picture, I have set to viible not visible, transparent
but still no image - The images are jpegs and tiffs

If I look at the image in the database file it opens ok - I have tried
linking and embedding but neither display on screen

Any patience and help you can offer will be gratefully received

Many Thanks