Cannot display OLE object inside report

[togo]

Hi. So we decided to use OLE objects to store images in our reports. The report however just shows a blank box. I run access 2007. Anyone know what I did wrong? Also in the form view, the OLE object does not show as photo either it just shows as icon.

On a side note, I've been working in access for a couple months solid now and found that Access' report system is so weak that I leave the report side of Access alone and write VBA routines to completely change the data it sees, then display the report, then close the report and change the data back... this seems easier to me than wrestling with Access relationships, since I am not a trained database person.

any help? thanks

edit: I said 2007 but its 2010 seems like they are probably the same

[June7]

There are differences in some features available in the two versions. Sometimes 2007 can't recognize 2010 file.

Are these static images, such as a logo? Or do you want dynamic display of images such as employee pictures?

Regardless, I haven't used the OLE controls for images, I use the Image control.

Don't understand issue you have with Access reports. What do you mean by 'weak'? Yes, sometimes VBA code is needed to manipulate data, whether or not relationships are established.

[togo]

yeah, I remember spending around a day and a half to get Access to display the data correctly in one database almost identical to another, but it wouldn't relate the data the same way... since then I use VBA through either a query or modify actual data in the table temporarily to produce reports

Anyways, the company wants for various liability purposes to have images actually stored in the database. They come from a camera so JPG's mostly.

[June7]

Displaying image from attachment field is a little tricky. Assuming the attachment field has only one document, try:

Report in design view, drag the attachment field from the field list to the report.

[togo]

I've had success with linking images but they want it to be embedded. Is this possible?

[June7]

If you don't want dynamic image display, no need for the attachment field. Set the Picture property of Image control. Create the Image control and navigate to the picture. Set the PictureType property to Embedded. Picture permanently established on form or report even if the original image is moved/deleted.

[togo]

THe company has decided now to link images instead

but its not working

switched picture type over to 'linked', everything shows visible, the data source is a text field that contains "c:\image.png" but it still shows nothing in report preview or output PDF

[June7]

Try the Image control, not OLE control. Set the ControlSource property to the text field.

The OLE control Picture property would not be a field reference, navigate to the location of the file (or type the path). This will store the actual path string in the property.

[togo]

I am using an image control. the OLE objects have been deleted from the report. IT's liked in the DATA source to a text field that also shows up in a text box on the report for me to confirm that the report knows where to look for the image

[togo]

I mucked around with datatypes for a while and something fixed it, dunno what.