I am having difficulty putting an image into my reports. I have created a calculated field in a query that creates the path to the image file. The image file is a jpg, but the extension is .0011. The path is being created correctly. However, the picture does not display. If I take the resulting path and open it in IE the image displays. The following is the code I am using.
Private Sub Report_Current()
On Error Resume Next
Me![BookImage].Picture = Me![filename]
End Sub
Filename is the field that contains the path to the image. I have tried hard coding the path to an image into the procedure without luck. As a test I have also tried renaming the extension to .jpg thinking maybe it was the odd extension that was the problem. Still no luck. I am running Office XP. Any suggestions would be greatly appreciated.
I might add that the report is rather complicated with 11 linked data sets and it contains three subreports. Everything else works great. I just can't get the image to display.
I have also tried a simple report with just the image without luck.
Christy
Private Sub Report_Current()
On Error Resume Next
Me![BookImage].Picture = Me![filename]
End Sub
Filename is the field that contains the path to the image. I have tried hard coding the path to an image into the procedure without luck. As a test I have also tried renaming the extension to .jpg thinking maybe it was the odd extension that was the problem. Still no luck. I am running Office XP. Any suggestions would be greatly appreciated.
I might add that the report is rather complicated with 11 linked data sets and it contains three subreports. Everything else works great. I just can't get the image to display.
I have also tried a simple report with just the image without luck.
Christy
Last edited:
