images to appear in report

[Guest]

I have an Access database that stores a catalogue of photographs.
Each photo has a record in the main table and one of the fields is called "image". This a link to a file on the hard drive i.e. "C:\images\photo25.jpg"

I would like to print a list of photos, showing a thumbnail image of each photo. How can I create a report that shows the description and the image next to it.

I can get a report to show the text descriptions but not the images (the best I achieved was to have photo #1 showing on all entries)

Many thanks if you have any ideas.

 

[Evi]

Have a search in Google Groups for a message called
"How to insert a picture in a database". I've described there how to do
this. Write back if it doesn't help.
Evi

I have an Access database that stores a catalogue of photographs.
Each photo has a record in the main table and one of the fields is called

"image". This a link to a file on the hard drive i.e.
"C:\images\photo25.jpg"

I would like to print a list of photos, showing a thumbnail image of each

photo. How can I create a report that shows the description and the image
next to it.

I can get a report to show the text descriptions but not the images (the

best I achieved was to have photo #1 showing on all entries)

 

[david james]

hi, this does seem to work if you have just 1 image per page of form or
report - but not if you want multiple images per page (as a thumbnail
print-out)

any ideas how to achieve this?

 

[Evi]

It does work for multiple images per page - I use it to create gift tags
with a variety of pictures and messages, 8 per page in 2 columns.

You wouldn't set Force New Page after the section and your pictures would
have to be small enough to fit on the page with the text. You would use Keep
Together in the Sorting/Grouping options to ensure that the picture stays on
the same page as your person. Your form would have to be a Continuous Form.

Is it that you expected Access to actually shrink a large picture into a
thumbnail? Unless this facility has been added to later version (I have 97)
then you could be out of luck . In that case you would have to use something
like IrfanView (freeware) to create a smaller version of your photo for your
database. Shrink the photo with Irfanview and save it under a new name .

Evi

 

[Larry Linson]

Is it that you expected Access to actually
shrink a large picture into a thumbnail?
Unless this facility has been added to later
version (I have 97) then you could be out
of luck .

Why do you say this? Have you had a bad experience using a SizeMode property
of "Zoom" on an Image or Bound OLE Frame Control? The resize may not be
quite as good quality as a good image processing program, but, in my
experience, it is really quite satisfactory.

In that case you would have to use
something like IrfanView (freeware)
to create a smaller version of your
photo for your database. Shrink the
photo with Irfanview and save it
under a new name .

I've never had a need to do this.

There are sample databases at http://accdevel.tripod.com illustrating three
approaches to handling images in Access and the download includes an article
discussing considerations in choosing which approach to use. They use Forms
to illustrate, but the same methods will work in Reports. Code that is
demonstrated in the OnCurrent event of a Form would be used in the Print
event of the Section where the Picture will be displayed in a Report.

Just to make sure you don't suffer from memory problems, it would be a good
idea to look at MVP Stephen Lebans' site,
http://www.lebans.com/printfailures.htm and take a look at the database and
documentation. By converting the Image files from .JPG to .BMP before
printing them, you may avoid your report using up all available memory.

Larry Linson
Microsoft Access MVP