Prev: Tracking Log In and Log Out Times of Users
Next: The ACOS function
From: Derek Wittman on 15 Feb 2005 10:59
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


From: John Nurick on 15 Feb 2005 15:09
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.

On Tue, 15 Feb 2005 10:59:54 -0500, "Derek Wittman"
<derekwittman(a)no.spam.com> wrote:

>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 [Microsoft Access MVP]

Please respond in the newgroup and not by email.
From: Derek Wittman on 16 Feb 2005 11:31
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" <j.mapSoN.nurick(a)dial.pipex.com> wrote in message
news:cgl411tr0mgf0o7scjlrp2sj52gkmihkmr(a)4ax.com...
> 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.
>
> On Tue, 15 Feb 2005 10:59:54 -0500, "Derek Wittman"
> <derekwittman(a)no.spam.com> wrote:
>
> >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 [Microsoft Access MVP]
>
> Please respond in the newgroup and not by email.


From: John Nurick on 16 Feb 2005 15:11
In that case, check out Application.FollowHyperlink.

On Wed, 16 Feb 2005 11:31:05 -0500, "Derek Wittman"
<derekwittman(a)no.spam.com> wrote:

>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" <j.mapSoN.nurick(a)dial.pipex.com> wrote in message
>news:cgl411tr0mgf0o7scjlrp2sj52gkmihkmr(a)4ax.com...
>> 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.
>>
>> On Tue, 15 Feb 2005 10:59:54 -0500, "Derek Wittman"
>> <derekwittman(a)no.spam.com> wrote:
>>
>> >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 [Microsoft Access MVP]
>>
>> Please respond in the newgroup and not by email.
>

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
From: Derek Wittman on 17 Feb 2005 07:47
Thanks, John. I'll certainly look into this.

Derek


"John Nurick" <j.mapSoN.nurick(a)dial.pipex.com> wrote in message
news:97a711lb6j4q458hhhp859bkllquteqcmp(a)4ax.com...
> In that case, check out Application.FollowHyperlink.
>
> On Wed, 16 Feb 2005 11:31:05 -0500, "Derek Wittman"
> <derekwittman(a)no.spam.com> wrote:
>
> >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" <j.mapSoN.nurick(a)dial.pipex.com> wrote in message
> >news:cgl411tr0mgf0o7scjlrp2sj52gkmihkmr(a)4ax.com...
> >> 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"
> >> <derekwittman(a)no.spam.com> wrote:
> >>
> >> >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 [Microsoft Access MVP]
> >>
> >> Please respond in the newgroup and not by email.
> >
>
> --
> John Nurick [Microsoft Access MVP]
>
> Please respond in the newgroup and not by email.


 | 
Pages: 1
Prev: Tracking Log In and Log Out Times of Users
Next: The ACOS function