J
Jerry K
I'm grouping similar records in a report that all use the
same product image. I only want the product picture to
appear once for the entire group. There is no "Hide
Duplicates" parameter for images.
I use an Image Frame to contain the picture and the
following Event Procedure method to find the image by
pointing to its path. Method from: http://www.microsoft-
accesssolutions.co.uk/bound_image_report.htm
Any way to hide duplicate pictures or use a totally
different method? Thank you very much!
Creating the Table to Store File and Path Data:
1. Create a new table that is named Imagetable and
then add a text field that is named ImagePath.
2. Open the Imagetable table in Datasheet view and
then add the path and the name of a bitmap file to each
record. The following examples show how the records might
look:
c:\windows\circles.bmp
c:\windows\waves.bmp
c:\windows\tiles.bmp
c:\windows\bubbles.bmp
Displaying Images in a Report
1. You can use the AutoReport Wizard to create a new
report that is based on the ImageTable table. Name the
report ImageReport.
2. Open ImageReport in Design view and then add an
image control to the report by using the Image tool in the
toolbox. You are prompted to select an image to insert.
Select any image that is available on your computer. Name
the control ImageFrame.
3. Set the Format Event of the "Details" section of
the report to the following Event Procedure:
Private Sub Detail_Format(Cancel As Integer, FormatCount
As Integer)
Me![Imageframe].picture = me![Imagepath]
End Sub
4. Open the ImageReport in Print Preview mode. Notice
that the report displays the corresponding bitmap for each
record.
Note: You may need to amend the file paths and image names
to correspond with images stored on your system.
same product image. I only want the product picture to
appear once for the entire group. There is no "Hide
Duplicates" parameter for images.
I use an Image Frame to contain the picture and the
following Event Procedure method to find the image by
pointing to its path. Method from: http://www.microsoft-
accesssolutions.co.uk/bound_image_report.htm
Any way to hide duplicate pictures or use a totally
different method? Thank you very much!
Creating the Table to Store File and Path Data:
1. Create a new table that is named Imagetable and
then add a text field that is named ImagePath.
2. Open the Imagetable table in Datasheet view and
then add the path and the name of a bitmap file to each
record. The following examples show how the records might
look:
c:\windows\circles.bmp
c:\windows\waves.bmp
c:\windows\tiles.bmp
c:\windows\bubbles.bmp
Displaying Images in a Report
1. You can use the AutoReport Wizard to create a new
report that is based on the ImageTable table. Name the
report ImageReport.
2. Open ImageReport in Design view and then add an
image control to the report by using the Image tool in the
toolbox. You are prompted to select an image to insert.
Select any image that is available on your computer. Name
the control ImageFrame.
3. Set the Format Event of the "Details" section of
the report to the following Event Procedure:
Private Sub Detail_Format(Cancel As Integer, FormatCount
As Integer)
Me![Imageframe].picture = me![Imagepath]
End Sub
4. Open the ImageReport in Print Preview mode. Notice
that the report displays the corresponding bitmap for each
record.
Note: You may need to amend the file paths and image names
to correspond with images stored on your system.