Pictures seem to reload on every page turn

[MrRundog]

I have successfully got the Report to display all pictures associated with its key via a sub report linked to a query. The query selects all pictures associated with the claim.

However It loads and formats the pictures every time you change to a new page. (as so does the forms I think)

This report takes a long time to load and uses a lot of memory. What is the
best way to load 5 or more pictures at once (so your pages don't need to reformat every time). Access stores Picture Path.

Cheers

 

[Ziggy1]

how are your pictures stored, did you embed or use linking, it is best to not store
( increases file size) images in the database, search this site for images in Database.

the method I have used in the past has images stored in a windows folder and linked via path using VB with the image control.

I'll check for an example at work tomorrow.

 

[MrRundog]

Hi, Thanks for your reply...

My images are stored in a folder - DataBase1\Pictures
The path is saved in the database - C:\DataBase1\Pictures\1202151502.jpg
The images are called on the Subform Thus

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me![Image15].Picture = Me![picPath]
End Sub

And are controled by a query attached to the subforms recordsource

SELECT tblPictures.picPath, tblClaims.claimID, tblPictures.picCaption
FROM tblClaims INNER JOIN tblPictures ON tblClaims.claimID = tblPictures.claimID;

 

[Ziggy1]

ok so you are doing it the way I suggested, could it be the file size of the image that is creating the delay?

One thing to try is remove page numbering Page 1 of x and just put the page #, it is not the most desirable but I had to do this once on a report that used Charts and formatting took a long time...just do it as an experiment.

does the query take time to load?

I checked my database and I have it in the "On Current" event. The images are approx 40-60 kb on average. I don't have a lot in there so I can't tell if there would be lag, but they load quickly. I would imagine if you have a large number in one folder it might low things dow as it searches. It might be a good idea to see if you can create folders to categorize images by region, year... what ever makes sense...think of something in your database related to the records ( to use as a folder name) that can be build into the path.

 

[MrRundog]

Thanks Ziggy - I tried all that but no change of any consequence - However - I just upgraded to access2007 and guess what - The problems gone completely!

Cheers
Andy

 

[Ziggy1]

hey, wow...something good actually came out of upgrading. I have a test copy of 2007 as we are upgrading this year...it takes some time to get used to.