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.
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.