Images failing to load - Any thoughts?

[XelaIrodavlas]

Hi All,

I posted a question the other day about using hyperlinks to display pictures on forms and reports (http://www.access-programmers.co.uk/forums/showthread.php?t=257891) and the problem was solved (thank you Access-Programmers!)

However I am now encountering another problem in that they aren't all actually showing.

To explain, I have a Report containing a sub-report which holds the pictures. Typically there are 3-4 pictures per A4 page and 2-3 pages, so not millions, but for some reason whenever I load I get between 1-3 pictures a page and the rest show as blank. I can repeatedly reload time after time and get a seemingly random number of successful images. I am completely baffled.

Does anyone know why this might be happening? The original images are on a network drive (but connectivity is good). They are high quality images but the load time isn't that bad (Is there a 'normal' load time for these things?) I wonder if it's just timing out after the first X pictures..

Any ideas could give me something to go off so don't be shy, please help!

Thanks,

 

[JHB]

How do you show the report by "Print Preview", if not then try "Print Preview".

 

[XelaIrodavlas]

Hi JHB,

yes I've been displaying in print preview, this is where i noticed the problem. But I tried putting it into layout view and strangely the images did load, although it was a lot slower.

Not sure if i can get the users to print from this screen though...

thanks,

 

[JHB]

Only a thought, did you try to print it out on paper from "Print Preview"?
I don't know if it helps, but can't you requery the image control each time a new picture should pop up?

 

[XelaIrodavlas]

Only a thought, did you try to print it out on paper from "Print Preview"?

It's a sad day JHB, I printed it and same problem, the ones that were loaded at the time printed but the rest is blank. This is making so little sense right now .

I don't know if it helps, but can't you requery the image control each time a new picture should pop up?

You can do that??? I can't figure out how, do tell

 

[JHB]

In the format event for the reports detail section, put in the below code, remember to change the control name to yours.
And use the "Print Preview" else the code isn't executed.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.ImageControlName.Requery
End Sub

Else if possible, post a stripped version of your database with some sample data/ pictures, (zip it).
One thing you also could try.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
   DoEvents
End Sub

[/QUOTE]