Repost - Hyperlinks and RunTime Errors

[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

 

[John Nurick]

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.

 

[Derek Wittman]

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]

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

 

[Derek Wittman]

Thanks, John. I'll certainly look into this.

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

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.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.

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