FedEx and Purolator Tracking from Form 1

[Begin76]

Hello,

This is a great site and has allowed me to further my knowledge of access greatly. Thank you to all the people that make it happen

My question has to do with tracking shipments from within my database. I am in the experimenting mode so I don't have a full table yet but it works for experiment purposes. What I am trying to acheive is as follows.

I have a form that the shipping department fills out when they ship and item They fill in the tracking number in tracking number field - tracknum. As we do shipping for other companies we use FedEx and Purolator - there is another lookup colloum for the shipcomp.

I have done what was described in the following post

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/702/qid/454961

and it works fine for both but I need to code an IIF statement that will allow me to look at the lookup collom and go to the right web address. I am having trouble with the IIF statement. I am coding in Form_Current.

I hope this makes sense!

 

[Begin76]

Hi,

I was able to figure it out last night. Thought I would post the code so anyone interested in doing the same could.

This is coded in the Form_Current event of a queried form.

If Me.ShipCompID.Value = 1 Then
checkfedex.HyperlinkAddress = "

http://www.fedex.com/cgi-bin/tracki...code=ca_english&initial=x&mps=y&tracknumbers=

" & tracknum & ""
End If

If Me.ShipCompID.Value = 2 Then
checkfedex.HyperlinkAddress = "

http://shipnow.purolator.com/shiponline/track/purolatortrack.asp?pinno=

" & tracknum & ""
End If

If Me.ShipCompID.Value = 3 Then
checkfedex.HyperlinkAddress = "

http://wwwapps.ups.com/WebTracking/...quiryNumber=T&loc=en_CA&InquiryNumber1="

& tracknum & "&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&AgreeToTermsAndConditions=yes&track.x=27&track.y=7"
End If

If Me.ShipCompID.Value = 4 Then
checkfedex.HyperlinkAddress = "

http://www.dayross.ca/ShipmentInquiry.asp?probill="

& tracknum & "&LangID=EN"
End If

We are using 4 carriers. They are FedEx, Purolator, UPS and Day and Ross. ShipCOmpID is a combo box with the shippers name and tracknum is the shipments tracking number. All work really well with exception of UPS. UPS website makes you click a check mark to agree to there terms before goin to the shipment tracking. This code will populate the tracking box on there website though.

 

[johngordon]

Here is the correct UPS code that gets around UPS websites check mark to agree to there terms before going to the shipment tracking:

http://wwwapps.ups.com/WebTracking/...ToTermsAndConditions=yes&track.x=20&track.y=8