Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    Indiana, USA
    Posts
    141
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Default Name for Hyperlink (2003)

    I have a database that stores web URL addresses for over 800 addresses. Specifically, the hyperlink is a "map" of the address, using the Yahoo map generator. I originally locate the address using Yahoo, and then copy & paste the URL address into the map field (hyperlink field) in my database. I then use the database to feed a web page. Everything works great, except I end up with a mile long URL address for the map link being displayed in web page. I was wondering if there is a way to "default" that long URL address in Access to just the word "map"? I thought about posting this in the FrontPage forum, but decided its more of an Access issue, since FrontPage will basically display whatever the database feeds it.

    As always I thank you in advance for your assistance.

  2. #2
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Name for Hyperlink (2003)

    are you outputting it in HTML? if so, can't you just output the link URL in HTML and use that to mask it to "Map"? if not, how are you feeding the web page?
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Default Name for Hyperlink (2003)

    A hyperlink consists of three parts separated by # characters:

    displayed name#hyperlink address#subaddress

    Only the middle part is obligatory. If the display name is missing, the hyperlink address is displayed. You can enter the map addresses like this:

    map#http://www.this_is_a_very_long_url.com

    The text before the # will become the displayed text. Note: you MUST enter or paste the complete URL, including http://, otherwise it won't be recognized.

  4. #4
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    Indiana, USA
    Posts
    141
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Default Name for Hyperlink (2003)

    Hans,

    I jumped the gun a little on my answer. I am assuming that I can merge the "map" and the URL fields in a query for the finished results. Am I thinking correctly on this?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Default Name for Hyperlink (2003)

    Sorry, I don't understand. Could you explain in more detail? Thanks.

  6. #6
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    Indiana, USA
    Posts
    141
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Default Name for Hyperlink (2003)

    You indicated that I need to add map# before the URL address, to get the word "map" to be the only item that is shown (with the URL hyperlinked to the word map). I was trying to figure out the easier method of adding the map# added to the URL, and I was going to do so inside of a query. I was going to created a field, and basically tie the map# and URL address together in the same field. Will this not work? I was thinking along these lines:

    "Map#" & [URL Address]

    If this won't work, how would you suggest?

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Default Name for Hyperlink (2003)

    OK, that should work without problems - I just tested it successfully. Remember, the URL must be include the http:// part.

  8. #8
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    Indiana, USA
    Posts
    141
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Default Name for Hyperlink (2003)

    Ok, well at least I was thinking along the right line. Thanks for you help Hans.

  9. #9
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    Indiana, USA
    Posts
    141
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Default Name for Hyperlink (2003)

    Hans,

    I'm missing something here. Here is the field I made up to join the Map and URL together:

    Map: "Map#" & [MapLink]

    And the data that is shown is:

    Map##http://maps.yahoo.com/maps/

    It is adding a second #, and displays the whole address, not the word "map".

    I think I got my coding crossed-up somewhere.

    Thanks for your help.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Default Name for Hyperlink (2003)

    It won't work that way. The expression was meant for an update query to modify the contents of the existing hyperlink field.

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Default Name for Hyperlink (2003)

    The easiest solution is to leave it a hyperlink field. You only need to run an update query to make it display "map", yet open the correct URL for each record automatically.

    If you change it to a text field, you'd have to use code to open the URL. (It would involve the FollowHyperlink method)

  12. #12
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    Indiana, USA
    Posts
    141
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Default Name for Hyperlink (2003)

    Hans,

    I ran an update query, however it added the word "map" to the URL field, but deleted the URL addresses. Think I missed a step.

  13. #13
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Default Name for Hyperlink (2003)

    What was the SQL for the update query?

  14. #14
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    Indiana, USA
    Posts
    141
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Default Name for Hyperlink (2003)

    I got the query to update properly. The other side of this problem is displaying the results in the web page. In my access database the field now shows the URL as "map" - however in my web page is still shows the full URL path. I know I am getting close.............

  15. #15
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Default Name for Hyperlink (2003)

    I'm afraid I can't help you with that.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •