Repost - Hyperlinks and RunTime Errors

  • Thread starter Thread starter Derek Wittman
  • Start date Start date
D

Derek Wittman

Good morning,
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
 
Hi Derek,

To store the full path but only display the filename, you need to
construct a string like this and store it in the Access hyperlink field:

filename#full path

e.g.

60filename.xls#v:\distcntr\dcdesign\projmgmt\capital05\CER\60\60filename.xls

If I've misunderstood you and you want to export a query in such a way
that one field will show up as hyperlinks in Excel, I don't know what
you should do; suggest you ask in an Excel forum.
 
Thanks, John.

Actually, I found an even different solution altogether. I have the
[projectpath] in a text field (as opposed to the hyperlink field). I have
the command button (although I am really considering a label) with a
hyperlink.texttodisplay and have the hyperlink.address of [ProjectPath] to
be .Followed.

This seems to be working like a charm. I'll be testing with a few more
projects to validate consistantly.

Thanks again!
Derek
 
In that case, check out Application.FollowHyperlink.

Thanks, John.

Actually, I found an even different solution altogether. I have the
[projectpath] in a text field (as opposed to the hyperlink field). I have
the command button (although I am really considering a label) with a
hyperlink.texttodisplay and have the hyperlink.address of [ProjectPath] to
be .Followed.

This seems to be working like a charm. I'll be testing with a few more
projects to validate consistantly.

Thanks again!
Derek
Click to expand...
 
Thanks, John. I'll certainly look into this.

Derek


John Nurick said:
In that case, check out Application.FollowHyperlink.

Thanks, John.

Actually, I found an even different solution altogether. I have the
[projectpath] in a text field (as opposed to the hyperlink field). I have
the command button (although I am really considering a label) with a
hyperlink.texttodisplay and have the hyperlink.address of [ProjectPath] to
be .Followed.

This seems to be working like a charm. I'll be testing with a few more
projects to validate consistantly.

Thanks again!
Derek
John Nurick said:
Hi Derek,

To store the full path but only display the filename, you need to
construct a string like this and store it in the Access hyperlink field:

filename#full path

e.g.
Click to expand...
60filename.xls#v:\distcntr\dcdesign\projmgmt\capital05\CER\60\60filename.xl s
If I've misunderstood you and you want to export a query in such a way
that one field will show up as hyperlinks in Excel, I don't know what
you should do; suggest you ask in an Excel forum.

On Tue, 15 Feb 2005 10:59:54 -0500, "Derek Wittman"

Good morning,
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.
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top