Any way to speed up form picture loading?

[mr_fish]

Hi all,

I've a form with an image on each page which is linked (not embedded) to filenames from another table. When moving through the forms the time it takes to import the picture is relatively slow, is there any method or hack I could use to speed this up?

The code I'm using at the moment:

Private Sub Form_Current()

Dim Picture As String

On Error GoTo PictureError

Picture = Me.Clipping_UNC & Me.Clipping_File_Name
Forms!REPORT_Coverage_Clippings![Image].Picture = Picture

PictureError:

If Err.Number = 2220 Then

Forms!REPORT_Coverage_Clippings![Image].Picture = "m:\setup\image.jpg"

Else

End If

End Sub

 

[Oldsoftboss]

Not easily.
2 things you could do:

1.. Get a faster computer
2.. Reduce the image size so the actual image is about the same size as the control on your forms.

Neither is practical, sorry

Dave

 

[ghudson]

I suggest that you hide the image until the user clicks a button to see the image when they want it. That will prevent the slowdown you have when they scroll the records.