Pass field value to end of HTML search address

[aleoni]

We have an internal tracking log that can be accessed independently from the full portal site by a web link which calls to a specific web address. At the end of that address is the unique Order Number for the your order. It's a pretty clunky process to get to this tracking log if you go through the usual search screens - but I have saved the web link for the log dialog/window (that provides the status) and am able to manually enter/change the value of the Order Number for the orders I am tracking to get a quick status.



That address looks like this:

http://xxxx.xxx.xxx.com/toyo/jsp/log.jsp?suf=LL&uso=38592924

The eight digits after the = sign can be changed, you press enter or go in IE and it refreshes with the order number you supplied.

This order number is also a field in an Access database I use to track my projects.

I would like to know if I am able to and how to pass the value in the Order Number field in my database to the "base" URL via a Clickable Button on my tracking form. So each record I move to, when I click that button, it will use the "http://xxxx.xxx.xxx.com/toyo/jsp/log.jsp?suf=LL&uso=" address and add the eight digit field value on the end in a dialog or browser window.

Any help / suggestions?

Thanks in advance for any help!

Sammy

[pbaldy]

You can concatenate them:

"http://xxxx.xxx.xxx.com/toyo/jsp/log.jsp?suf=LL&uso=" & Me.ControlWithTheNumber

[aleoni]

I am not very independent with Access and VBA... I received a compile error... here is what I entered:

__________________________________________________ __
Private Sub SOTS_Log_Click()

"http://xxxx.xxx.xxx.com/toyo/jsp/log.jsp?suf=LL&uso=" & Me.QW_T_Access_USO

End Sub
__________________________________________________ __

QW_T_Access_USO is the control field

Any thoughts?

[pbaldy]

Sorry, it can't be by itself like that. I thought you had existing code you were trying to add it to. Check out FollowHyperlink in VBA help, and use that string in conjunction with that.