Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    May 2001
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Accessing Files on Web Server (Access XP)

    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.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Accessing Files on Web Server (Access XP)

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

  3. #3
    New Lounger
    Join Date
    May 2001
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Accessing Files on Web Server (Access XP)

    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"?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Accessing Files on Web Server (Access XP)

    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.

  5. #5
    New Lounger
    Join Date
    May 2001
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Accessing Files on Web Server (Access XP)

    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.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Accessing Files on Web Server (Access XP)

    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?

  7. #7
    New Lounger
    Join Date
    May 2001
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Accessing Files on Web Server (Access XP)

    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •