Report Containing error message

jadair

Registered User.
Local time
Today, 23:12
Joined
Jun 13, 2003
Messages
17
Trying to run a report which takes the text from a filed in the table and then links it to and image file on the hard drive. I ran the report with only a couple of fields and it ran perfectly it displayed the images with no problem. However, when I go to run the report against the ehtire database i am getting two different error messages, ERROR 2220 "Microsoft access can't open the file" the other error "This image is not supported by MS Access" but it is a jpg and tall the others work . The strange thing is that the majority of teh images in the database are in jpg format, most of them work, there is only a select few that don't work and that is where I get the message. I check the path names the image format, and I even opened the images on their own and everything worked perfectly, I only have a problem when I am running this report. Does anyone have an idea on how I could either fix this problem, or just have access skip over these photos and continue the report. Here is the code I used.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me![ImageFrame].Picture = Me![ImagePath]
End Sub
I apperciate any insight, this databse is driving me insane.
 
The pictures that are causing problems have you tried renaming/converting them to a different file format ie. .gif or even .jpeg as opposed to .jpg

Are there spaces in the image name?? if there are, remove them and see if that helps
 

Users who are viewing this thread

Back
Top Bottom