D
Derek Wittman
Good afternoon,
I am working on a budgeting tool that saves (in Excel) a file to my network.
The filename and the entire path are stored in my tblProject table. I want
to be able to use the application (form) to call up the Project. The full
path looks something like this:
v:\distcntr\dcdesign\projmgmt\capital05\CER\60\60filename.xls
The filename is only 60filename.xls.
I want to only have the filename as the texttodisplay and have the entire
path as the HyperlinkAddress. Unfortunately, like some others on the
newsgroups, I'm getting the "Run-Time Error 7980 The HyperlinkAddress or
HyperlinkSubAddress property is read-only for this
hyperlink."
Can someone offer some assistance? I've considered using a mid function.
However, there may be times when the character counts don't line up precisely
enough.
Thank you in advance!
Derek Wittman
I am working on a budgeting tool that saves (in Excel) a file to my network.
The filename and the entire path are stored in my tblProject table. I want
to be able to use the application (form) to call up the Project. The full
path looks something like this:
v:\distcntr\dcdesign\projmgmt\capital05\CER\60\60filename.xls
The filename is only 60filename.xls.
I want to only have the filename as the texttodisplay and have the entire
path as the HyperlinkAddress. Unfortunately, like some others on the
newsgroups, I'm getting the "Run-Time Error 7980 The HyperlinkAddress or
HyperlinkSubAddress property is read-only for this
hyperlink."
Can someone offer some assistance? I've considered using a mid function.
However, there may be times when the character counts don't line up precisely
enough.
Thank you in advance!
Derek Wittman