Display picture from file on internet

[Jonathan Blitz]

I have an Acces project where I wish to display a picture that is held on an
internet site of ours.
The pictures are in files that have been uploaded by the user.

Do I have to put them in an SQL Server table to be able to get to them or is
there a way to link to them directly from with Access?

--
Jonathan Blitz
AnyKey Limited
Israel

Tel: (972) 8 9790365

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."

 

[Rob Oldfield]

I've never used it in a production situation but you could try the ActiveX
"Microsoft Web Brower" control. You set what it displays by using...

Me.ctlName.Navigate2 "http://www.whatever.com/whatever.gif"

 

[Jonathan Blitz]

That's works great.
However, I now realise I need something more complicated.

I need to be able to present to the user a list of the pictures on the
server and let the user choose one to see.
How would I do this?

--
Jonathan Blitz
AnyKey Limited
Israel

Tel: (972) 8 9790365

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."

 

[Rob Oldfield]

Hmmm. Not something that I've ever tried. I'd guess that you should be
able to run a DOS script (via the Shell command) to run an ftp command and
create a text file from that, which could then be used to populate a list
box (or whatever). But I certainly couldn't come up with any detail. Might
be worth reposting again to ask if anyone has a good method of getting a
list of *.xyz files at a particular site.