Hi There.
I have been using an access database to manage a large variety of PDF files.
I have written some code that looks for a file with a specific name on my computer and appends the hyperlink to that file into a table when it finds it.
I am now looking to improve this further:
Is there a way that I can insert hyperlinks into a table that are independent of a file's name?
I other words, when I change the name of a file, the hyperlink won’t break, as it is linked to another variable that is unique to that one specific file.
In the ideal world I wopuld be able to write code that would enable me to point to a file. A hyperlink to that file would then be inserted into a table. I would then have a subsequent code that would refresh these hyperlinks periodically if my files have moved. Changing the name of the file should not matter.
Any ideas would be greatly appreciated.
THX!
Regards,
FGP
I have been using an access database to manage a large variety of PDF files.
I have written some code that looks for a file with a specific name on my computer and appends the hyperlink to that file into a table when it finds it.
I am now looking to improve this further:
Is there a way that I can insert hyperlinks into a table that are independent of a file's name?
I other words, when I change the name of a file, the hyperlink won’t break, as it is linked to another variable that is unique to that one specific file.
In the ideal world I wopuld be able to write code that would enable me to point to a file. A hyperlink to that file would then be inserted into a table. I would then have a subsequent code that would refresh these hyperlinks periodically if my files have moved. Changing the name of the file should not matter.
Any ideas would be greatly appreciated.
THX!
Regards,
FGP
