H
Harley Feldman
I am using the Application.FileDialog.(msoFileDialogFilePicker) method from the Office library to select a file on my hard drive when the user clicks a command button ("Browse") on a form. The file dialog object opens, I am able to select the file, and I can return the absolute hyperlink address. I have stored this absolute address in a text field with the "Is Hyperlink" property = "yes". However, when I click on the Hyperlink, the "My Documents" folder opens not the file.
How do I either only store the relative path to the file in the text field or how do I get the absolute path hyperlink to open to the right file? I would prefer the former approach since it would allow the database folder to move without impacting all of addresses of the files in the folder where hyperlinks had been created.
Harley
How do I either only store the relative path to the file in the text field or how do I get the absolute path hyperlink to open to the right file? I would prefer the former approach since it would allow the database folder to move without impacting all of addresses of the files in the folder where hyperlinks had been created.
Harley