Hi
I am having a very frustrtaing problem occur with a report I am trying to run. I have norrowed the problem down to the following:
I have a subreport that contains an image box - ImageJpg - detailed a embedded and stretch.
In the detail of the form I have the following code:
"
On Error GoTo Error_Function
Me.ImageJPG.Picture = Nz(Me.Image, "")
DoEvents
Exit Sub
Error_Function:
End Sub
"
The image file path is set by me.image which is also on the form but set to visible false.
My problem is this:
When I open the pictures look like they display fine, however I scroll through the 900 pictures and about 200 are not displayed. I added some extra code to the above to log, good jpg and bad jpg. When I view the actual logged as bad jpgs they are fine. I decided to crop all the bad jpgs to see if any corruption within the files, so cropped and re saved.
I'm majorly confused because each time I run the program I get different pictures displaying, I even did a run just on the jpgs logged as bad with my code on one report run and they all appear fine.
Basically if i run against the lot I hae many missing and in no particular order. If I run on those missing they appear!! ???
Whats going on?
Please help.
I am having a very frustrtaing problem occur with a report I am trying to run. I have norrowed the problem down to the following:
I have a subreport that contains an image box - ImageJpg - detailed a embedded and stretch.
In the detail of the form I have the following code:
"
On Error GoTo Error_Function
Me.ImageJPG.Picture = Nz(Me.Image, "")
DoEvents
Exit Sub
Error_Function:
End Sub
"
The image file path is set by me.image which is also on the form but set to visible false.
My problem is this:
When I open the pictures look like they display fine, however I scroll through the 900 pictures and about 200 are not displayed. I added some extra code to the above to log, good jpg and bad jpg. When I view the actual logged as bad jpgs they are fine. I decided to crop all the bad jpgs to see if any corruption within the files, so cropped and re saved.
I'm majorly confused because each time I run the program I get different pictures displaying, I even did a run just on the jpgs logged as bad with my code on one report run and they all appear fine.
Basically if i run against the lot I hae many missing and in no particular order. If I run on those missing they appear!! ???
Whats going on?
Please help.
