Results 1 to 2 of 2
  1. #1
    johnsawan79 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2014
    Posts
    1

    Question Hyperlinking Image or Office Documents using a network path & table values as a link.

    Hi, thanks for visiting my thread. I'm a novice user of access & totally no programming background. I have this database that i need to add hyperlinks to references such as images & office documents like word & excel. The files I was hoping to hyperlink were located on a network path ("\\144.44.12.229\Images\"), then I have the image file name in the table (123456) & it's a ".jpg" file. So the whole path for the image is ("\\144.44.12.229\PD Models\123456.jpg). How can I make this possible? Hoping to achieve this to be automatically generated each time I create a record since the files are all located in one path only.

    As for the office documents, they are located in a network path ("\\Lazlotus\")as well but unlike images the documents are situated in different sub-folders etc... but a have a text file that contains all the individual paths for each file in the parent folder which can be used as a full path reference for each available document in the directory. Below are the sample contents of the text file. The last value in the path is a record value in my table. Hoping to achieve a lookup like effect.

    \\Lazlotus\Type1\2010\Funky\0200012.xlsx
    \\Lazlotus\Type2\2012\Normal\0200013.docx
    \\Lazlotus\Type1\2010\Best\0200014.xlsx


    \\Lazlotus\Type2\2013\Weird\0200015.xls
    \\Lazlotus\Type1\2014\Artistic\0200017.doc

    There will be instances that some document/image may not be available, so this will serve as a verification tool for me to see if the record has an available image & document.

    Thanks!

  2. #2
    lfpm062010 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Location
    US
    Posts
    415
    For your images, if all the files name is already in an Access table (say "IMAGEFILE") with field "FILENAME".
    If you have a table (say "VERIFYFILE") has already a field (say "FILENAME") that is "HYPERLINK".

    Using the following query, will generate the link in table "VERIFYFILE". Once you open the table "VERIFYFILE", you can click on the link to see if file can be viewed.

    INSERT INTO VERIFYFILE ( FILENAME )
    SELECT "\\144.44.12.229\Images\" & IMAGEFILE.FILENAME & ".jpg"
    FROM IMAGEFILE;

    Similarly, then office documents will be like

    INSERT INTO VERIFYFILE ( FILENAME )
    SELECT "\\Lazlotus\" & OFFICEFILE.FILENAME
    FROM OFFICEFILE;

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

Similar Threads

  1. Replies: 5
    Last Post: 10-28-2013, 08:09 AM
  2. Link image files to Access table
    By amerifax in forum Access
    Replies: 12
    Last Post: 07-03-2013, 03:50 AM
  3. Need help with network path....
    By cplmckenzie in forum Programming
    Replies: 8
    Last Post: 03-27-2013, 08:40 PM
  4. picture image link on a table textbox
    By john_gringo in forum Access
    Replies: 5
    Last Post: 11-04-2011, 02:21 PM
  5. Cannot load image in Microsoft Office Document Imaging
    By chrisjohns in forum Programming
    Replies: 1
    Last Post: 04-03-2009, 02:45 AM

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