Link to home
Start Free TrialLog in
Avatar of dsoderstrom
dsoderstrom

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(Cancel As Integer)

    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?
ASKER CERTIFIED SOLUTION
Avatar of Gozreh
Gozreh
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dsoderstrom
dsoderstrom

ASKER

Perfect!  Thank You.