Button to open specific webpage in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there, and thanks in advance for any help you can give me. Here's what I'm trying to do

I have UPS tracking numbers in a query. I can look at them via a form, but I want to add a button next to the number that will start the default web browser and enter in a specific URL that I want to use. Here's the kicker..

UPS has an "I agree" form that you have to go through every time to ensure that you are not datamining, etc. I can bypass that page (I want to bypass it) by putting my tracking number directly in the middle of the aforementioned URL above, and need to know how to set this up to have access pull that unique URL in, instead of just having the button take me to the UPS "I agree" page. I'm hoping this is making sense..

Using
Win X
Access 200

Thanks
Mark
 
I have nevertried it, but you should be able to set the buttons "hyperlink
address property" in vba code and include the tracking number.

something like (untested code)...


me!GoToWebButton.hyperlinkaddress = "www..." & [TrackingNumber]



Look in Access helpfor the hyperlink address property and there is a good
example.



Rick



Hi there, and thanks in advance for any help you can give me. Here's what
I'm trying to do:

I have UPS tracking numbers in a query. I can look at them via a form, but
I want to add a button next to the number that will start the default web
browser and enter in a specific URL that I want to use. Here's the
kicker...

UPS has an "I agree" form that you have to go through every time to ensure
that you are not datamining, etc. I can bypass that page (I want to bypass
it) by putting my tracking number directly in the middle of the
aforementioned URL above, and need to know how to set this up to have access
pull that unique URL in, instead of just having the button take me to the
UPS "I agree" page. I'm hoping this is making sense...

Using:
Win XP
Access 2000

Thanks,
Mark
 
Rick,

I am a total idiot with VB, and don't understand any of
the commands. Can you tell me what the expressions mean
below? I may be able to figure out what to put in for
each if I know what they are asking for...

Mark
 
Mark,

I am working on a project that needs to do the same as what you are doing. I
haven't got to the UPS part yet. Give me the URL you want to use and I will work
out the code you need and send you the code. We'll both then be able to interact
with UPS.

Steve
PC Datasheet
(e-mail address removed)


Crapsjack said:
Hi there, and thanks in advance for any help you can give me. Here's what I'm trying to do:

I have UPS tracking numbers in a query. I can look at them via a form, but I
Click to expand...
want to add a button next to the number that will start the default web browser
and enter in a specific URL that I want to use. Here's the kicker...
UPS has an "I agree" form that you have to go through every time to ensure
Click to expand...
that you are not datamining, etc. I can bypass that page (I want to bypass it)
by putting my tracking number directly in the middle of the aforementioned URL
above, and need to know how to set this up to have access pull that unique URL
in, instead of just having the button take me to the UPS "I agree" page. I'm
hoping this is making sense...
 
Back
Top