Product Images in Report

[Pat Coleman]

We have 700 products and have images taken of all of our products in .PSD
and .GIF formats.

Would like to generate an inventory report with image, product name, stock#
and price.

Is it possible and if so what is the command or method to include the images
of these product in our inventpry report generated in Access.

Right now our inventory report pulls data from a table. The table is a
linked table from Excel where there are many formulas working out things
like price etc ..

We also have a field for "image file locations" to product images stored
here but my attempts to get the product image to be displayed in Access have
so far failed.

This image field has something like c:\inventory\images\product001.gif
to describe the location of the image.

If any one has any other advice on this matter, would be glad to hear from
you.

Thanks

Pat

 

[SA]

Pat:

Include and image control on your report, it will require to you specify an
image when first placed on the report. Then include the path in your query.
In the On Print event for the specific record, add code like this:

If Len(Me!fldImagePath) >0 Then
Me!MyImageControl.Picture = Me!fldImagePath
Me!MyImageControl.Visible = True
Else
Me!MyImageControl.Visible = False
End if

Note however that the Image control will not support your PSD file, but only
jpg, gif, bmp or emf files.