asked on
Displaying UPS Tracking Number information using VBA
I am trying to display information for a UPS tracking number by double clicking on the tracking number on a subform in Access 2010.
I have the following code on the double click event for the tracking number field:
Private Sub Tracking_Number_DblClick(C
UPSID = "C:\Program Files\Internet Explorer\IEXPLORE.EXE http://wwwapps.ups.com/WebTracking/track?loc=en_US&ID=" & Tracking_Number
X = Shell(UPSID, vbMaximizedFocus)
End Sub
This code brings up the UPS Tracking site but it does not fill in the Tracking Number and display information for it. Is there a way to do this?
I have the following code on the double click event for the tracking number field:
Private Sub Tracking_Number_DblClick(C
UPSID = "C:\Program Files\Internet Explorer\IEXPLORE.EXE http://wwwapps.ups.com/WebTracking/track?loc=en_US&ID=" & Tracking_Number
X = Shell(UPSID, vbMaximizedFocus)
End Sub
This code brings up the UPS Tracking site but it does not fill in the Tracking Number and display information for it. Is there a way to do this?
Microsoft Access
Last Comment
dsoderstrom
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Perfect! Thank You.