Displaying Web Images in Form

[Ray Stantz]

Hi all,

I searched and couldn't find an answer to this question.

I am using access 2003 as a frontend and Sharepoint 2.0 (web) as a backend to store tables so that users can access the DB outside of the network by having the FE installed on their laptops and its linked to the tables on Sharepoint. I'm working out the kinks and am having issues displaying jpeg images on my form that i have stored on Sharepoint .

The DB used to be stored on a local network and i was able to display pics using the network address where the picture is located (i.e. G:\Images\sample.jpg) and this code:

     If Len(Me![CurrentUserName]) <> 0 Then
        Me![ImgControl].Picture = Me![CurrentUserName]
    End If
Else
    Me.CurrentUserName.Undo
    Cancel = True
    MsgBox "Sorry, you do not have access to this form", _
        vbOKOnly, "Important Information"
    Exit Sub
End If

However, it does not work for URLs (i.e. http://cdn-write.demandstudios.com/upload//6000/400/40/3/176443.jpg)... I tried the Web Browser control as well and keep getting an error message that the object is not supported and i am inclined to think its the code that is causing that error but i'm not sure what code would be appropriate for the type of control... any suggestions would be greatly appreciated!

Ray...

 

[CEH]

I'll give this a shot in the dark..... having never worked with sharepoint I don't know if this applies... But... You should never use a Drive letter when linking FE to BE... The G drive on one computer might be the F drive on another..... Always link using My Network Places...So use a path to sharepoint without using a drive letter... Just a thought.