Image control how do I direct it to a location on a webserver

[Trowser]

Basically I am using an SQL DB and in one of the fields I have the location of a file that has the picture of the item in the SQL database

Now when the user browses through I want this picture to load up into a image object

I am using

Image1 = Loadpicture ("http:\\Webserver.com\Image" & rec!Imagename)

But I keep getting errors that it cannot find the file

what am I doing wrong?

 

[vbkris]

try this
Image1 = Loadpicture ("

http://Webserver.com/Image"

& rec!Imagename)

 

[Trowser]

Nope that didn't work I changed the \ to / but the semi-collon gave me a syntax error

but it still doesn't work still get the same error

Run-Time error 75

File/Path Access Error

 

[vbkris]

sorry bout the semicolon it was a mistake,
Image1 = Loadpicture ("

http://Webserver.com/Image"

& rec!Imagename)

what is the error?

 

[Trowser]

Run-Time error 75
File/Path Access Error

it just canna find the file yet if I type it into my browser its there

 

[strongm]

The semicolon gets inserted by tektips.

 

[Trowser]

anyone know what I is doing wrong?

 

[Trowser]

ok I think I have some of it figured out but I am still getting problems

Set Image1.datasource = Rec!Icon

Now how do I set up a pointer in the SQL database

 

[Trowser]

more info

I have tried to have

Http://webserver.com/Icon/Component.jpg

in the SQL DB with no luck