Pass to external website

[mattc66 via AccessMonster.com]

I have a form that tracks orders with the shipping info. One fld holds
tracking number. I have a double click event on this fld that opens a custom
UPS website tracking site.

How do I pass the tracking number from the form to the website?

Thanks
Matt

 

[sqlhack]

Matt:
I have not checked this yet but you shoudl be able to do it by passing
it in the url. I have put a example below but note that you will have
to play around with the url a little bit, also if this is a production
enviroment I would not recomend doing it this was, as UPS is liable to
chage their web site at any given time. For a production application I
would look to see if UPS has any web services advailble.

Example:

dim AddressPrefix, AddressSuffix, AddressToBrowseTo as string
AddressPrefix =
"http://wwwapps.ups.com/WebTracking/...ion=5.0&loc=en_US&Requester=UPSHome&tracknum="
AddressSuffix="&AgreeToTermsAndConditions=yes&ignore=&track.x=39&track.y=13"
AddressToBrowseTo = AddressPrefix & Field1 & AddressSuffix
' Then from here just navigate to the variable "AddressToBrowseTo"

Kevin Meziere