How to open web page (1 Viewer)

richard.rios

New member
Local time
Today, 12:51
Joined
Jan 17, 2014
Messages
3
Hello all,
I am trying to create a button that opens up a webpage. I get how to create a hyperlink on a button. The problem is, I need to open a specific page depending on the information in a text box.

The text box displays the tracking number for the current record. That number is populated automatically via a control source. The problem is that I need to open different web pages depending on the tracking number displayed. For example, UPS has a specific start to their number (1ZX....). Other trucking companies have a specific format, also.

So how do I tell it to look at the tracking number and then open the corresponding web page?
 

AlexHedley

Registered User.
Local time
Today, 19:51
Joined
Aug 28, 2012
Messages
171
You could use some VBA with a SELECT CASE

Check the tracking number and set which type you need then build the URL.
 

richard.rios

New member
Local time
Today, 12:51
Joined
Jan 17, 2014
Messages
3
Thanks for the reply. I probably went about it the long way. I used a dlookup for each order based on the trucking company and have it opening the corresponding site. It works, though.
 

Users who are viewing this thread

Top Bottom