Solved

Displaying UPS Tracking Number information using VBA

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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

762 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

19 Experts available now in Live!

Get 1:1 Help Now