Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

work-around for hyperlink reserved character restriction

Discussion in 'Information Technology' started by Wendy Farkas, Nov 2, 2005.

  1. Wendy Farkas

    Wendy Farkas
    Expand Collapse
    Guest

    kb article #207852 notes that you can't hyperlink to documents with # in the
    name, which prevents you from linking to an anchor in a web page. Is there a
    work-around for this limitation?

    TIA
     
  2. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Wendy, the article is dealing with file names that have a # in the name, and
    the problem is that Access truncates the name there and assumes the rest
    *is* the anchor name in the page.

    You should have no problem at all inserting a link such as:
    http://allenbrowne.com/tips.html#apps
    You might see it display with a hyphen, but it should work correctly.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Wendy Farkas" <WendyFarkas@discussions.microsoft.com> wrote in message
    news:AA698655-7165-4F08-9318-91407AE68F75@microsoft.com...
    > kb article #207852 notes that you can't hyperlink to documents with # in
    > the
    > name, which prevents you from linking to an anchor in a web page. Is there
    > a
    > work-around for this limitation?
    >
    > TIA
     
  3. Wendy Farkas

    Wendy Farkas
    Expand Collapse
    Guest

    Allen,

    Thanks for your response.

    For this URL
    http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials
    I had entered the following in a field of the type hyperlink
    http://www.mvps.org/dmcritchie/excel/excel.htm-tutorials

    It returned the following message:
    Unable to open http://www.mvps.org/dmcritchie/excel/excel.htm-tutorials
    The Internet site reports that the item you requested could not be found
    (HTTP/1.0 404)

    When I entered the URL you mentioned, replacing the "#" with "-", it
    returned the following message:
    Unable to open apps. Cannot open the specified file.

    Did I miss something/do something wrong?

    Wendy

    "Allen Browne" wrote:

    > Wendy, the article is dealing with file names that have a # in the name, and
    > the problem is that Access truncates the name there and assumes the rest
    > *is* the anchor name in the page.
    >
    > You should have no problem at all inserting a link such as:
    > http://allenbrowne.com/tips.html#apps
    > You might see it display with a hyphen, but it should work correctly.
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "Wendy Farkas" <WendyFarkas@discussions.microsoft.com> wrote in message
    > news:AA698655-7165-4F08-9318-91407AE68F75@microsoft.com...
    > > kb article #207852 notes that you can't hyperlink to documents with # in
    > > the
    > > name, which prevents you from linking to an anchor in a web page. Is there
    > > a
    > > work-around for this limitation?
    > >
    > > TIA

    >
    >
    >
     
  4. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Right-click the hyperlink to edit it.
    In the dialog, you can see the Display text, and the link.
    The display text will probably show the dash, but the link should contain
    the #.

    That works fine here (tested in Access 2003.)

    Another way to test what is actually in the field would be to use
    HyperlinkPart() in the Immediate window (Ctrl+G).

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Wendy Farkas" <WendyFarkas@discussions.microsoft.com> wrote in message
    news:3A7A07E6-F207-4F15-9B71-EA6C953DC67C@microsoft.com...
    > Allen,
    >
    > Thanks for your response.
    >
    > For this URL
    > http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials
    > I had entered the following in a field of the type hyperlink
    > http://www.mvps.org/dmcritchie/excel/excel.htm-tutorials
    >
    > It returned the following message:
    > Unable to open http://www.mvps.org/dmcritchie/excel/excel.htm-tutorials
    > The Internet site reports that the item you requested could not be found
    > (HTTP/1.0 404)
    >
    > When I entered the URL you mentioned, replacing the "#" with "-", it
    > returned the following message:
    > Unable to open apps. Cannot open the specified file.
    >
    > Did I miss something/do something wrong?
    >
    > Wendy
    >
    > "Allen Browne" wrote:
    >
    >> Wendy, the article is dealing with file names that have a # in the name,
    >> and
    >> the problem is that Access truncates the name there and assumes the rest
    >> *is* the anchor name in the page.
    >>
    >> You should have no problem at all inserting a link such as:
    >> http://allenbrowne.com/tips.html#apps
    >> You might see it display with a hyphen, but it should work correctly.
    >>
    >> --
    >> Allen Browne - Microsoft MVP. Perth, Western Australia.
    >> Tips for Access users - http://allenbrowne.com/tips.html
    >> Reply to group, rather than allenbrowne at mvps dot org.
    >>
    >> "Wendy Farkas" <WendyFarkas@discussions.microsoft.com> wrote in message
    >> news:AA698655-7165-4F08-9318-91407AE68F75@microsoft.com...
    >> > kb article #207852 notes that you can't hyperlink to documents with #
    >> > in
    >> > the
    >> > name, which prevents you from linking to an anchor in a web page. Is
    >> > there
    >> > a
    >> > work-around for this limitation?
    >> >
    >> > TIA

    >>
    >>
    >>
     
  5. Wendy Farkas

    Wendy Farkas
    Expand Collapse
    Guest

    Allen,

    I edited the hyperlink as you suggested - link still doesn't work from the
    field. I'm using Access 2000. Do you think they added a functionality to the
    2003 version that would explain why you're getting it and I'm not?

    I'm just beginning to learn how to work with the VB Editor, so I probably
    didn't get the 2nd part of your suggestion right. I typed into the Immediate
    window:
    HyperlinkPart (http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials)
    which returned: Compile error: expected: list separator or )

    W
    "Allen Browne" wrote:

    > Right-click the hyperlink to edit it.
    > In the dialog, you can see the Display text, and the link.
    > The display text will probably show the dash, but the link should contain
    > the #.
    >
    > That works fine here (tested in Access 2003.)
    >
    > Another way to test what is actually in the field would be to use
    > HyperlinkPart() in the Immediate window (Ctrl+G).
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "Wendy Farkas" <WendyFarkas@discussions.microsoft.com> wrote in message
    > news:3A7A07E6-F207-4F15-9B71-EA6C953DC67C@microsoft.com...
    > > Allen,
    > >
    > > Thanks for your response.
    > >
    > > For this URL
    > > http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials
    > > I had entered the following in a field of the type hyperlink
    > > http://www.mvps.org/dmcritchie/excel/excel.htm-tutorials
    > >
    > > It returned the following message:
    > > Unable to open http://www.mvps.org/dmcritchie/excel/excel.htm-tutorials
    > > The Internet site reports that the item you requested could not be found
    > > (HTTP/1.0 404)
    > >
    > > When I entered the URL you mentioned, replacing the "#" with "-", it
    > > returned the following message:
    > > Unable to open apps. Cannot open the specified file.
    > >
    > > Did I miss something/do something wrong?
    > >
    > > Wendy
    > >
    > > "Allen Browne" wrote:
    > >
    > >> Wendy, the article is dealing with file names that have a # in the name,
    > >> and
    > >> the problem is that Access truncates the name there and assumes the rest
    > >> *is* the anchor name in the page.
    > >>
    > >> You should have no problem at all inserting a link such as:
    > >> http://allenbrowne.com/tips.html#apps
    > >> You might see it display with a hyphen, but it should work correctly.
    > >>
    > >> --
    > >> Allen Browne - Microsoft MVP. Perth, Western Australia.
    > >> Tips for Access users - http://allenbrowne.com/tips.html
    > >> Reply to group, rather than allenbrowne at mvps dot org.
    > >>
    > >> "Wendy Farkas" <WendyFarkas@discussions.microsoft.com> wrote in message
    > >> news:AA698655-7165-4F08-9318-91407AE68F75@microsoft.com...
    > >> > kb article #207852 notes that you can't hyperlink to documents with #
    > >> > in
    > >> > the
    > >> > name, which prevents you from linking to an anchor in a web page. Is
    > >> > there
    > >> > a
    > >> > work-around for this limitation?
    > >> >
    > >> > TIA
    > >>
    > >>
    > >>

    >
    >
    >
     
  6. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Hi Wendy.

    Okay, I just tried this in Access 2000, and I did receive the last error
    message you posted. It seems that A2000 does parse the name incorrectly if
    you paste it into the link.

    However, you can fix that if you right-click the entry and Edit the
    hyperlink. Everything up to the # is shown in the "Text to Display", and
    everything after the # is shown in the "Type of file or Web page name".
    That's clearly wrong. You need the entire link in the 2nd box. If you paste
    the text in there, the link should work.

    So, it looks like the Access 2000 *interface* parses the hyperlink
    incorrectly, and you can work around that by editing the link yourself.

    HTH

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Wendy Farkas" <WendyFarkas@discussions.microsoft.com> wrote in message
    news:F831DFA2-2CEA-4268-A5F8-5ADE23BE86FD@microsoft.com...
    > Allen,
    >
    > I edited the hyperlink as you suggested - link still doesn't work from the
    > field. I'm using Access 2000. Do you think they added a functionality to
    > the
    > 2003 version that would explain why you're getting it and I'm not?
    >
    > I'm just beginning to learn how to work with the VB Editor, so I probably
    > didn't get the 2nd part of your suggestion right. I typed into the
    > Immediate
    > window:
    > HyperlinkPart (http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials)
    > which returned: Compile error: expected: list separator or )
    >
    > W
    > "Allen Browne" wrote:
    >
    >> Right-click the hyperlink to edit it.
    >> In the dialog, you can see the Display text, and the link.
    >> The display text will probably show the dash, but the link should contain
    >> the #.
    >>
    >> That works fine here (tested in Access 2003.)
    >>
    >> Another way to test what is actually in the field would be to use
    >> HyperlinkPart() in the Immediate window (Ctrl+G).
    >>
    >> --
    >> Allen Browne - Microsoft MVP. Perth, Western Australia.
    >> Tips for Access users - http://allenbrowne.com/tips.html
    >> Reply to group, rather than allenbrowne at mvps dot org.
    >>
    >> "Wendy Farkas" <WendyFarkas@discussions.microsoft.com> wrote in message
    >> news:3A7A07E6-F207-4F15-9B71-EA6C953DC67C@microsoft.com...
    >> > Allen,
    >> >
    >> > Thanks for your response.
    >> >
    >> > For this URL
    >> > http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials
    >> > I had entered the following in a field of the type hyperlink
    >> > http://www.mvps.org/dmcritchie/excel/excel.htm-tutorials
    >> >
    >> > It returned the following message:
    >> > Unable to open
    >> > http://www.mvps.org/dmcritchie/excel/excel.htm-tutorials
    >> > The Internet site reports that the item you requested could not be
    >> > found
    >> > (HTTP/1.0 404)
    >> >
    >> > When I entered the URL you mentioned, replacing the "#" with "-", it
    >> > returned the following message:
    >> > Unable to open apps. Cannot open the specified file.
    >> >
    >> > Did I miss something/do something wrong?
    >> >
    >> > Wendy
    >> >
    >> > "Allen Browne" wrote:
    >> >
    >> >> Wendy, the article is dealing with file names that have a # in the
    >> >> name,
    >> >> and
    >> >> the problem is that Access truncates the name there and assumes the
    >> >> rest
    >> >> *is* the anchor name in the page.
    >> >>
    >> >> You should have no problem at all inserting a link such as:
    >> >> http://allenbrowne.com/tips.html#apps
    >> >> You might see it display with a hyphen, but it should work correctly.
    >> >>
    >> >> --
    >> >> Allen Browne - Microsoft MVP. Perth, Western Australia.
    >> >> Tips for Access users - http://allenbrowne.com/tips.html
    >> >> Reply to group, rather than allenbrowne at mvps dot org.
    >> >>
    >> >> "Wendy Farkas" <WendyFarkas@discussions.microsoft.com> wrote in
    >> >> message
    >> >> news:AA698655-7165-4F08-9318-91407AE68F75@microsoft.com...
    >> >> > kb article #207852 notes that you can't hyperlink to documents with
    >> >> > #
    >> >> > in
    >> >> > the
    >> >> > name, which prevents you from linking to an anchor in a web page. Is
    >> >> > there
    >> >> > a
    >> >> > work-around for this limitation?
    >> >> >
    >> >> > TIA
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>

    >
     
  7. Wendy Farkas

    Wendy Farkas
    Expand Collapse
    Guest

    Grrr...

    I've edited the hyperlink so that
    text to display reads: http://www.mvps.org/dmcritchie/excel/excel.htm -
    tutorials
    file/web pg name reads:
    http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials

    Clicking on the link from the field navigates to:
    http://www.mvps.org/dmcritchie/excel/tutorials

    Maybe it's just not doable in this version of Access

    W

    "Allen Browne" wrote:

    > Hi Wendy.
    >
    > Okay, I just tried this in Access 2000, and I did receive the last error
    > message you posted. It seems that A2000 does parse the name incorrectly if
    > you paste it into the link.
    >
    > However, you can fix that if you right-click the entry and Edit the
    > hyperlink. Everything up to the # is shown in the "Text to Display", and
    > everything after the # is shown in the "Type of file or Web page name".
    > That's clearly wrong. You need the entire link in the 2nd box. If you paste
    > the text in there, the link should work.
    >
    > So, it looks like the Access 2000 *interface* parses the hyperlink
    > incorrectly, and you can work around that by editing the link yourself.
    >
    > HTH
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "Wendy Farkas" <WendyFarkas@discussions.microsoft.com> wrote in message
    > news:F831DFA2-2CEA-4268-A5F8-5ADE23BE86FD@microsoft.com...
    > > Allen,
    > >
    > > I edited the hyperlink as you suggested - link still doesn't work from the
    > > field. I'm using Access 2000. Do you think they added a functionality to
    > > the
    > > 2003 version that would explain why you're getting it and I'm not?
    > >
    > > I'm just beginning to learn how to work with the VB Editor, so I probably
    > > didn't get the 2nd part of your suggestion right. I typed into the
    > > Immediate
    > > window:
    > > HyperlinkPart (http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials)
    > > which returned: Compile error: expected: list separator or )
    > >
    > > W
    > > "Allen Browne" wrote:
    > >
    > >> Right-click the hyperlink to edit it.
    > >> In the dialog, you can see the Display text, and the link.
    > >> The display text will probably show the dash, but the link should contain
    > >> the #.
    > >>
    > >> That works fine here (tested in Access 2003.)
    > >>
    > >> Another way to test what is actually in the field would be to use
    > >> HyperlinkPart() in the Immediate window (Ctrl+G).
    > >>
    > >> --
    > >> Allen Browne - Microsoft MVP. Perth, Western Australia.
    > >> Tips for Access users - http://allenbrowne.com/tips.html
    > >> Reply to group, rather than allenbrowne at mvps dot org.
    > >>
    > >> "Wendy Farkas" <WendyFarkas@discussions.microsoft.com> wrote in message
    > >> news:3A7A07E6-F207-4F15-9B71-EA6C953DC67C@microsoft.com...
    > >> > Allen,
    > >> >
    > >> > Thanks for your response.
    > >> >
    > >> > For this URL
    > >> > http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials
    > >> > I had entered the following in a field of the type hyperlink
    > >> > http://www.mvps.org/dmcritchie/excel/excel.htm-tutorials
    > >> >
    > >> > It returned the following message:
    > >> > Unable to open
    > >> > http://www.mvps.org/dmcritchie/excel/excel.htm-tutorials
    > >> > The Internet site reports that the item you requested could not be
    > >> > found
    > >> > (HTTP/1.0 404)
    > >> >
    > >> > When I entered the URL you mentioned, replacing the "#" with "-", it
    > >> > returned the following message:
    > >> > Unable to open apps. Cannot open the specified file.
    > >> >
    > >> > Did I miss something/do something wrong?
    > >> >
    > >> > Wendy
    > >> >
    > >> > "Allen Browne" wrote:
    > >> >
    > >> >> Wendy, the article is dealing with file names that have a # in the
    > >> >> name,
    > >> >> and
    > >> >> the problem is that Access truncates the name there and assumes the
    > >> >> rest
    > >> >> *is* the anchor name in the page.
    > >> >>
    > >> >> You should have no problem at all inserting a link such as:
    > >> >> http://allenbrowne.com/tips.html#apps
    > >> >> You might see it display with a hyphen, but it should work correctly.
    > >> >>
    > >> >> --
    > >> >> Allen Browne - Microsoft MVP. Perth, Western Australia.
    > >> >> Tips for Access users - http://allenbrowne.com/tips.html
    > >> >> Reply to group, rather than allenbrowne at mvps dot org.
    > >> >>
    > >> >> "Wendy Farkas" <WendyFarkas@discussions.microsoft.com> wrote in
    > >> >> message
    > >> >> news:AA698655-7165-4F08-9318-91407AE68F75@microsoft.com...
    > >> >> > kb article #207852 notes that you can't hyperlink to documents with
    > >> >> > #
    > >> >> > in
    > >> >> > the
    > >> >> > name, which prevents you from linking to an anchor in a web page. Is
    > >> >> > there
    > >> >> > a
    > >> >> > work-around for this limitation?
    > >> >> >
    > >> >> > TIA
    > >> >>
    > >> >>
    > >> >>
    > >>
    > >>
    > >>

    > >

    >
    >
    >
     
  8. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Worked on mine, Wendy.
    Tested in A2000, Service Pack 3.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Wendy Farkas" <WendyFarkas@discussions.microsoft.com> wrote in message
    news:BB839DAB-92B7-47E3-B8BD-488B4295DB1D@microsoft.com...
    > Grrr...
    >
    > I've edited the hyperlink so that
    > text to display reads: http://www.mvps.org/dmcritchie/excel/excel.htm -
    > tutorials
    > file/web pg name reads:
    > http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials
    >
    > Clicking on the link from the field navigates to:
    > http://www.mvps.org/dmcritchie/excel/tutorials
    >
    > Maybe it's just not doable in this version of Access
    >
    > W
    >
    > "Allen Browne" wrote:
    >
    >> Hi Wendy.
    >>
    >> Okay, I just tried this in Access 2000, and I did receive the last error
    >> message you posted. It seems that A2000 does parse the name incorrectly
    >> if
    >> you paste it into the link.
    >>
    >> However, you can fix that if you right-click the entry and Edit the
    >> hyperlink. Everything up to the # is shown in the "Text to Display", and
    >> everything after the # is shown in the "Type of file or Web page name".
    >> That's clearly wrong. You need the entire link in the 2nd box. If you
    >> paste
    >> the text in there, the link should work.
    >>
    >> So, it looks like the Access 2000 *interface* parses the hyperlink
    >> incorrectly, and you can work around that by editing the link yourself.
    >>
    >> "Wendy Farkas" <WendyFarkas@discussions.microsoft.com> wrote in message
    >> news:F831DFA2-2CEA-4268-A5F8-5ADE23BE86FD@microsoft.com...
    >> > Allen,
    >> >
    >> > I edited the hyperlink as you suggested - link still doesn't work from
    >> > the
    >> > field. I'm using Access 2000. Do you think they added a functionality
    >> > to
    >> > the
    >> > 2003 version that would explain why you're getting it and I'm not?
    >> >
    >> > I'm just beginning to learn how to work with the VB Editor, so I
    >> > probably
    >> > didn't get the 2nd part of your suggestion right. I typed into the
    >> > Immediate
    >> > window:
    >> > HyperlinkPart
    >> > (http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials)
    >> > which returned: Compile error: expected: list separator or )
    >> >
    >> > W
    >> > "Allen Browne" wrote:
    >> >
    >> >> Right-click the hyperlink to edit it.
    >> >> In the dialog, you can see the Display text, and the link.
    >> >> The display text will probably show the dash, but the link should
    >> >> contain
    >> >> the #.
    >> >>
    >> >> That works fine here (tested in Access 2003.)
    >> >>
    >> >> Another way to test what is actually in the field would be to use
    >> >> HyperlinkPart() in the Immediate window (Ctrl+G).
     
  9. Raimundo Silva

    Raimundo Silva
    Expand Collapse
    Guest

    Hello. I'm not espek ingles. Ok? Bay Bay
     

Share This Page