Results 1 to 2 of 2
  1. #1
    kennyritch
    Guest

    Adding a Dynamic URL to my Form (2000)

    Hi Folks

    I have a form which reads customer information from my database. The primary key for a customer is compID and we have individual pages on the web based on this compID - in other words, each of our customers has a unique webpage based on their compID.

    An example of a URL is www.ourwebsite.com/companypage.htm?compID=12345

    Is is possible to incorprate this URL on my form so that I can click it an go directly to a particular customer's webpage? Obviously the url can't be hard-coded on to the form as each address will be different for a customer.

    Any ideas how I can do this?

    Cheers,
    Kenny.

  2. #2
    Lounger
    Join Date
    Apr 2001
    Location
    Khon Kaen, Thailand
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding a Dynamic URL to my Form (2000)

    Hi,

    You have several ways to handle this. Do you plan to insert the URL into the table or just gather the URL when a use clicks a command button. If the latter, apply the code below and play with it to fit your need.

    Private Sub cmdURL_Click()
    Dim strURL as String
    strURL = "www.ourwebsite.com/companypage.htm?compID=" & Me.compID
    FollowHyperlink strURL
    End Sub

    HTH.

    Tim K.

Posting Permissions

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