Question Graphics in MS Access (1 Viewer)

[sysHvV]

I have a graphics question about MS Access: Thusfar I have used the following sub:

Private Sub GetFoto(Path As String)
On Error Resume Next

    If moTabPage <> "PagVisu" Then Exit Sub
    If Me.Groep <> "Pic" Then
        Me.MPict.Picture = dxProgDir & "\Pics\NoPreview.bmp"
    Else
        Me.MPict.Picture = Path
    End If
End Sub

But with that Access will import the picture and that takes time and an annoying progress indicator will be displayed. So I am looking for a different method to load/display my pictures (mostly JPG)
Any/All help will be greatly appreciated, and will be repaid with my undying gratitude (although a shiny lamborghini would be more fitting, unfortunately thats all I have to offer)
_________________________________________________________
Beauty resides in the eye of the beholder

 

[georgedwilkinson]

I have no clue whether this will solve your problem or not...just throwing it out there.

What if you just store the results of your if statement into a table and have a timer on an invisible form that just sits and reads that table for new activity and loads the graphic for you? I know it's a long shot.

 

[Simon_MT]

You are better to use jpegs. They should be instantaneous depending on size, you should be looking at 100Kb or less to have no major speed degraduation.

Bitmaps have really caught on as they are inefficient.

Simon