Results 1 to 2 of 2
2001-07-25, 09:55 #1kennyritchGuest
Adding a Dynamic URL to my Form (2000)
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?
2001-07-25, 10:14 #2
- Join Date
- Apr 2001
- Khon Kaen, Thailand
- Thanked 0 Times in 0 Posts
Re: Adding a Dynamic URL to my Form (2000)
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