Hyperlink does not open image

Posted on 2014-08-12
Last Modified: 2014-08-13

I have a field that stores a hyperlink that when we had a local server would open the picture from the link in Paint.  We have since moved this server to the cloud and I updated the hyperlink to the new server.

"\\\folder\fileName.jpg".  If I click on the link, nothing happens.  If I paste the link into either my browser or windows explored, it opens perfect.  I went and set the server to a trusted location but that did not help either.
Question by:vmccune
    LVL 84
    Make sure a program is associated with the "jpg" extension, otherwise the hyperlink won't know which program to use to open those files. If this is truly in the "cloud" (i.e. SSAS, or something similar), you'd have to do that on the cloud server. If you're just storing data in the cloud, then you'd have to make the change on the machine where Access is running.

    Author Comment

    The program is set to Paint.  It works fine if I paste the link into either a browser or windows explorer.  The only thing stored on the cloud is the picture.
    LVL 84
    Can you use Application.FollowHyperlink:

    Application.FollowHyperlink "\\\folder\fileName.jpg"

    If so, then you'd have to be sure that the image path is stored in a plain text field, and NOT a hyperlink field.

    Author Comment

    If it worked before, why would I need to do this now?

    Author Comment

    Ok. this did work.  

    I will change the field to a text box and run the application.followhyperlink on the click property.

    How will I transfer the field value and put it between the " "'s?

    LVL 84

    Accepted Solution

    Just do this:

    Application.FollowHyperlink Me.YourField

    Author Closing Comment

    Perfect.  Only addendum is it also works with a hyperlink filed and does not have to be a text field.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now