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!