Hyperlink from a form for UPS tracking

[longbillduck]

We download our shipping information from the UPS computer system into a Access database

This includes the UPS tracking number

Our Sales department wants to be able to click on a link, which in turn would bring them to the UPS tracking site and display the progress of a shipment

What I'm trying to do is,based on our Sales Order Number, extract the appropriate tracking number and insert it into a hyperlink.

The following is the link, but I have substituted the tracking number with questions marks

http://wwwapps.ups.com/etracking/tr...yNumber4=&InquiryNumber5=&track.x=0&track.y=0

Of course, the tracking number will be changing with each Sales Order

Any help would be greatly appreciated

Thanks in advance

Art

 

[parkville]

If you are using Access 2000 or 2002, check out FollowHyperlink in Help, you need to do something like:
Dim strURL As String
'txtUPS is name of form control holding UPS no:
strURL = "http:..." & Me!txtUPS & "...."
Application.FollowHyperlink strURL

I do not know if this is available pre-Access 2000.

 

[rajeessh]

Else have a lable as a control
and set this in the hyperlink addrees of the lable

We will get this as a link and hence work out

Me.Label2.HyperlinkAddress = StrURL
Me.Label2.ForeColor = 16711680
Me.Label2.FontUnderline = True
Me.Label2.Caption = StrURL

Try this in setting the controls
Lable2 will be your label name

 

[longbillduck]

Parkville

I am using Access 2000 but could not find the FollowHyperlink in Help you mentioned in your post


I'm a real novice at this, but do you mean

& Me!txtUPS &

is calling for the Label or the Text Box?