Solved

Displaying UPS Tracking Number information using VBA

Posted on 2016-07-29
2
102 Views
Last Modified: 2016-09-14
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?
0
Comment
Question by:dsoderstrom
2 Comments
 
LVL 10

Accepted Solution

by:
Gozreh earned 500 total points
ID: 41735084
0
 

Author Comment

by:dsoderstrom
ID: 41735667
Perfect!  Thank You.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question