Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Location
    Northfield, Minnesota, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlink question (Access 2000)

    I need to put a hyperlink on a form that will have a record number as a URL parameter.
    I have a form that lists student tutors and their past experience and such
    I want to put a unique link that looks like http://www.mysite.edu/tutoring/mailt...m?tutor=007007
    The number will change for each record.
    How would you do this?
    I have tried several things but I can't figure this out yet.
    Thank you for your help.
    Al

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

    Re: Hyperlink question (Access 2000)

    I would "fake" the hyperlink. Create a label or text box or command button, whatever you like. If you wish, you can make the caption or text look like a hyperlink by making it blue and underlined.

    In the On Click event procedure, use FollowHyperlink to go to the desired URL:

    Private Sub Something_Click()
    Application.FollowHyperlink "http:www.mysite.edu/tutoring/mailtutor.cfm?tutor=" & Me.[TutorID]
    End Sub

    Substitute the appropriate names.

  3. #3
    New Lounger
    Join Date
    Feb 2003
    Location
    Northfield, Minnesota, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink question (Access 2000)

    That worked wonderfully!
    You are most excellent!
    Thank you.
    Al

Posting Permissions

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