Results 1 to 9 of 9
  1. #1
    guitarzycki is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2016
    Posts
    20

    Linked photos to url on an Access 2013 form


    Greetings all! I have created a continuous form to use as a category selector. It displays images that the user clicks on to narrow down the selection. I have an Access form that refers to a text field that is a link to an image file on my server such as "\\wi101wsf\Company\Machining\MASTER_PROCESS_DATAB ASE\Resources\Images\InventoryLevels\points.jpg". As you well know, this only allows access to the images while connected to the network. What I have done is uploaded all the images to an Amazon Web Services S3 bucket. I can access the images by url like this https://s3.us-east-2.amazonaws.com/j...CTROOPTICS.jpg by copying and pasting into browser or even linking to the image in Word 2013 but it does not work when I use this url in the text field in my Access 2013 table. Any suggestions?

    Thanks,

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You need the full path in the Access table
    In this case: https :// s3.us-east-2.amazonaws.com/jzarzyckiphotos/Trijicon+Machining+Database+Photos/Resources/Images/InventoryLevels/ELECTROOPTICS.jpg
    without the added spaces on the part in red
    Then use Application.FollowHyperlink to open it.

    NOTE: I've deliberately didn't use the link button as the forum software will automatically shorten it - had to spoof it
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    guitarzycki is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2016
    Posts
    20
    I'm not sure why the post truncated the url like that, but it is complete in the table as shown here. Click image for larger version. 

Name:	Capture.PNG 
Views:	14 
Size:	21.6 KB 
ID:	35094

    The result of this is a missing image as shown here:Click image for larger version. 

Name:	Capture2.PNG 
Views:	15 
Size:	89.5 KB 
ID:	35095

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    The forum software always shortens long URLs even when you don't use the web link button

    That's odd. When I tried it before the link worked. Now I'm getting an Access denied error

    Just tried it on another web image not stored at Amazon. it worked fine
    So perhaps just a problem with that image?
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    guitarzycki is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2016
    Posts
    20
    Could you send me the link to the image you used so I can try that?

  6. #6
    guitarzycki is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2016
    Posts
    20
    I'm really just looking for the image to display. The click will be handled by other logic

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    I've tried several without problems e.g. http://www.blogcdn.com/www.engadget....-inception.jpg

    Just tried yours again. Still seems to be a fault with that one.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  8. #8
    guitarzycki is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2016
    Posts
    20
    Quote Originally Posted by ridders52 View Post
    I've tried several without problems e.g. http://www.blogcdn.com/www.engadget....-inception.jpg

    Just tried yours again. Still seems to be a fault with that one.
    Yeah, that one doesn't show the image either. I can open it when I click it or paste it into my browser, but using it in the text box field does not show the image on my continuous form.

  9. #9
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    OK try the attached which has 3 image URLs

    The first is yours which gives error 8 - cannot download the information you requested.
    Oddly that's not an Access error

    The second is a dropbox file which works for me but may not for you
    The last is the link I just posted & which also works for me

    Both the button & clicking on the textbox should work the same.
    I've also tested with the textbox formatted as a hyperlink & not. Same result

    Tested in both 2010 & 2016 - I've only got 2013 on a VM so not tested .... but it should be the same

    Oddly the first time I tested your Amazon link, it showed the image ...but not now

    URLTest.zip
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 17
    Last Post: 04-09-2018, 04:39 PM
  2. Replies: 3
    Last Post: 03-06-2017, 02:13 PM
  3. Replies: 11
    Last Post: 08-26-2016, 11:51 AM
  4. Replies: 0
    Last Post: 06-23-2016, 05:09 PM
  5. Replies: 4
    Last Post: 08-29-2011, 12:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums