U
Umar
I created a field called FileName in Access the type is hyperlink then I
imported from Excel the list of thousand of file names such as
“\\MAIN-SERVER\DOWN-SERVER\My_Documents.doc“ after the import succeeded then
I clicked to open the file, however it does not work, it won't open the file.
I tried an experiment and paste that file name in Word, Ctrl-Click does not
open it.
So, next I put the cursor to the end of File Name hit the Backspace button
which invalidates the linkage, then I hit the Enter button after which Word
made the File Name a linkage again. I do the Ctrl-Click and the new document
is opened.
Following that I Copied this File Name from the Word document and Paste it
in the FileName field in Access. Guess what! it works and open
My_Documents.doc, so now I can open My_Documents.doc from Access.
However I don’t want to do this thousand times, any idea how to automate
this process or do it another way?
Any help is appreciated.
imported from Excel the list of thousand of file names such as
“\\MAIN-SERVER\DOWN-SERVER\My_Documents.doc“ after the import succeeded then
I clicked to open the file, however it does not work, it won't open the file.
I tried an experiment and paste that file name in Word, Ctrl-Click does not
open it.
So, next I put the cursor to the end of File Name hit the Backspace button
which invalidates the linkage, then I hit the Enter button after which Word
made the File Name a linkage again. I do the Ctrl-Click and the new document
is opened.
Following that I Copied this File Name from the Word document and Paste it
in the FileName field in Access. Guess what! it works and open
My_Documents.doc, so now I can open My_Documents.doc from Access.
However I don’t want to do this thousand times, any idea how to automate
this process or do it another way?
Any help is appreciated.