Accessing Files on Web Server (Access XP)

Topic

New Reply

I have two questions related to accessing jpeg files on a web server via Access:
I have an employee database. Each employee record contains a field with a hyperlink to a jpeg file on the company intranet. The jpeg is the employee’s picture.

My questions are:
1. What is the best way to display the employee’s picture on a form using the intranet as the picture source?
2. Is there code that accomplishes the same as “save target as”? I am looking to save a local copy of each jpeg in a directory.

Thanks.

Reply | Quote

Replies

You yourself pointed to post 370163 recently. The Microsoft Webbbrowser control can be used to display images that reside on an intranet or internet server.

Reply | Quote

Thanks Hans.
Yes I came across that thread while looking for my answer, but I haven’t gotten it to work yet.
I am still working on it. I thought there might be an alternative solution.

Any ideas for the automated saving of the contents of a hyper link a la “save target as”?

Reply | Quote

I don’t know of an alternative, and I don’t know how to program the webbrowser control (apart from navigating to a web page). If you don’t receive an answer here within a day or two, you might consider asking in the Web Design, Coding and Scripting forum.

Reply | Quote

Access was crashing when I tried to add the browser object (also crashes when trying to import from Excel). I may need to reinstall.

So I used another machine and was able to add the “Microsoft Browser” object.
However, I get an error message when I open the form:
—————————
Microsoft Visual Basic
—————————
Compile error:
Method or data member not found

It highlights WebBrowser0
My line of code in the On Current event is as follows:

Me.WebBrowser0.Object.navigate [Picture Link]

Hopefully, I’m just doing something simple wrong.

Reply | Quote

Does it work if you omit Object, i.e.

Me.WebBrowser0.Navigate [Picture Link]

Umm, your web browser control is named WebBrowser0, isn’t it? Oh, and is Internet Explorer your default browser?

Reply | Quote

I thought my browser was webbrowser0, but it is webbrowser1.
Must have been the various tries.

Now it works!

Hans – Thanks so much for you help!

Reply | Quote

I thought my browser was webbrowser0, but it is webbrowser1.
Must have been the various tries.

Now it works!

Hans – Thanks so much for you help!

Reply | Quote

Does it work if you omit Object, i.e.

Me.WebBrowser0.Navigate [Picture Link]

Umm, your web browser control is named WebBrowser0, isn’t it? Oh, and is Internet Explorer your default browser?

Reply | Quote

Access was crashing when I tried to add the browser object (also crashes when trying to import from Excel). I may need to reinstall.

So I used another machine and was able to add the “Microsoft Browser” object.
However, I get an error message when I open the form:
—————————
Microsoft Visual Basic
—————————
Compile error:
Method or data member not found

It highlights WebBrowser0
My line of code in the On Current event is as follows:

Me.WebBrowser0.Object.navigate [Picture Link]

Hopefully, I’m just doing something simple wrong.

Reply | Quote

I don’t know of an alternative, and I don’t know how to program the webbrowser control (apart from navigating to a web page). If you don’t receive an answer here within a day or two, you might consider asking in the Web Design, Coding and Scripting forum.

Reply | Quote

You yourself pointed to post 370163 recently. The Microsoft Webbbrowser control can be used to display images that reside on an intranet or internet server.

Reply | Quote