Anyone Know?

  • Thread starter Thread starter Arrowx8
  • Start date Start date
A

Arrowx8

Guest
Hello, I have a question.
As you may or may not know, variables for websites must be declared in the URL like this: http://www.mysite.com/page.html?variablename=value
Is there any way to take the information in a DB field and stick it on the end of the url, like where it says "value".

Like this:
http://www.mysite.com/page.html?variablename= + [myvarialbe]
So when someone clicks on the button, it goes to it.
I tried adding a hyperlink to the button in a form and put a text-field variable on the end:
http://www.mysite.com/page.html?variablename=[Forms]![myform]![textfield1]
That didn't seem to work. Do you have any ideas?

All I want to do is add two variables together into one (one after the other), is there a way to do that in access?
Thanks In advance.
 
If you need the hyperlink to be dynamic (and that sounds like what you are getting at) try:

Private Sub myButton_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
myButton.HyperlinkAddress = "http://www.mysite.com/page.html?variablename=" & [Forms]![myform]![textfield1]
End Sub

I haven't tried it, but I think it should work. Let me know if it works.

Jeff
 
it works thanks tons!
 

Users who are viewing this thread

Back
Top Bottom