Results 1 to 5 of 5
  1. #1
    Greyhound is offline Novice
    Windows XP Access 2000
    Join Date
    Jul 2012
    Posts
    3

    Adding additional info to a hyperlink address

    Hi I need a solution to the following if anyone could help.



    on a menu page in my database I have a button that when clicked goes to a specific part of a website. The site has changed its format so now the link doesn't work.

    what I need to do is find a solution that allows me to add info to the link and then execute the link

    i.e www.mywebpage/information/ and then I need to add date and place after selecting each of them from a drop down box

    so final hyperlink address would look like www.mywebpage/information/01-07-2012/London


    Thanks in advance

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,622
    The date part of the link needs to be dynamic? Review
    http://allenbrowne.com/casu-09.html
    http://allenbrowne.com/func-GoHyperlink.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Greyhound is offline Novice
    Windows XP Access 2000
    Join Date
    Jul 2012
    Posts
    3
    Quote Originally Posted by Greyhound View Post
    Hi I need a solution to the following if anyone could help.

    on a menu page in my database I have a button that when clicked goes to a specific part of a website. The site has changed its format so now the link doesn't work.

    what I need to do is find a solution that allows me to add info to the link and then execute the link

    i.e www.mywebpage/information/ and then I need to add date and place after selecting each of them from a drop down box

    so final hyperlink address would look like www.mywebpage/information/01-07-2012/London


    Thanks in advance
    I have managed to combined the 3 text fields in a new text box to create what looks like the address I want i.e www.mywebpage/information/01-07-2012/London and although I have said it is a hyperlink nothing happens when I click on it.

    Any ideas how I can make this combined text into a URL link

    Thanks

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,622
    Review the first link I referenced.

    The hyperlink string is composed of 3 parts separated by # character. So the ControlSource of textbox would be:
    ="#http://www.mywebpage/information/01-07-2012/London#"
    or
    ="some title here if you want one#http://www.mywebpage/information/01-07-2012/London#"
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Greyhound is offline Novice
    Windows XP Access 2000
    Join Date
    Jul 2012
    Posts
    3
    Thanks manage to solve it by using followhyperlink.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. VBA to assign address to Hyperlink
    By jip911 in forum Programming
    Replies: 3
    Last Post: 08-02-2018, 04:33 PM
  2. Replies: 4
    Last Post: 04-14-2012, 07:22 PM
  3. Adding additional fields in form
    By ThebigCt in forum Forms
    Replies: 2
    Last Post: 02-23-2012, 12:33 AM
  4. Adding a email address on form
    By akhlaq768 in forum Forms
    Replies: 3
    Last Post: 02-07-2012, 09:11 AM
  5. Adding an additional WHERE clause
    By Pells in forum Queries
    Replies: 7
    Last Post: 10-28-2010, 12:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums