How do I insert OLE objects attached to a form in a report?

A

AOO MAS

I need to insert a particular photo (OLE object) with a particular item in a
report. I have attached the photo in the form correctly, but cannot figure
out how to get it on the report. Help!
 
E

Evi

If you are using an OLE field for your photos in your actual table so that
they are stored in your databse then you just add a Bound Image control to
your report from the Toolbox and change the Control Source to your OLE
field.

If you want to store your photos in a separate foldet then:

In your table add an ImagePath field which contains the file path to your
image and an ImageName field which contains the image name. (The 2 fields
make it easier to edit, if you ever need to move your images and you can
always have a Default Value in the ImagePath field)
In the query on which your report is based, concatenate the 2 fields
Pic: ImagePath & ImageName.

In Access 97 and 2000
In your report in Design View, add an Image from the toolbox (I've named
mine MyImage)
In Acc2K it insists that you choose a pic to go in it. Just choose anything.

On the Format page of the Properties change the Picture Type to Linked and
the Size Mode to Zoom (if the pics are different sizes) or Clip (if the
pictures will always fit into your frame)

In the Format Event of the section that contains the picture have

Me![MyImage].Picture = Me![Pic]



Evi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top