Results 1 to 6 of 6
  1. #1
    breezett93 is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    53

    Storing image location in a text box and using that for an image control source to display image

    On data entry, I want the user to input the file path (\\server\folder\imageName.jpg) of where the image is stored. When they want to view records on a continuous form, I want the images displayed. The reason is that I have converted the back end to SQL Server which doesn't like large images stored in the table.

    This post seemed like a good solution: https://answers.microsoft.com/en-us/...a-37cab82634ce. However, my image control is blank when viewing the form. So, I'm not sure what I'm doing wrong.

    Anyone have a better solution or know the fix for this one?

    Thanks.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Should work.

    How are users inputting the path, just typing or selecting from FileDialog?

    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    breezett93 is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    53
    The users are typing in the path currently. Should I take a look at FileDialog?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Yes. Typing a path string is just too prone to errors. However, if you want to use UNC path (\\server) code will probably have to do substitution of drive letter path.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    breezett93 is offline Advanced Beginner
    Windows 7 64bit Access 2013 64bit
    Join Date
    Feb 2017
    Posts
    53
    I'm attaching a picture of how the form currently looks using Access attachments. I'd like the form to visually function the same.
    Click image for larger version. 

Name:	Color.PNG 
Views:	12 
Size:	78.4 KB 
ID:	42413

    Is there perhaps a better solution than what I originally suggested?

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Better solution for displaying images on form? Not that I can imagine.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 10
    Last Post: 02-25-2019, 07:36 PM
  2. Replies: 2
    Last Post: 03-14-2018, 11:10 AM
  3. Replies: 1
    Last Post: 12-26-2016, 08:57 AM
  4. Replies: 3
    Last Post: 07-13-2015, 12:07 PM
  5. Image Control with Filepath as Source
    By tennislvr7 in forum Forms
    Replies: 1
    Last Post: 01-22-2014, 10:59 PM

Tags for this Thread

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