Solved

Displaying UPS Tracking Number information using VBA

Posted on 2016-07-29
2
95 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
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…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

816 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now