Going to URL Interesting Question

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

Guest

I created a database for my book collection. One of the fields is the ISBN of
the book. Amazon.com has a product page for every book by going to
http://www.amazon.com/exec/obidos/ASIN/[ISBN].
Therefore what I'm trying to do and can't figure out how is to have it so
that whenever I double-click on the field ISBN in my form, it will add the
value to the end of "http://www.amazon.com/exec/obidos/ASIN/" (so that, for
example, I have "http://www.amazon.com/exec/obidos/ASIN/0782123260") then
launch Internet Explorer and load that page.
Thanks in advance, Mike
 
MiniMike said:
I created a database for my book collection. One of the fields is the
ISBN of the book. Amazon.com has a product page for every book by
going to http://www.amazon.com/exec/obidos/ASIN/[ISBN].
Therefore what I'm trying to do and can't figure out how is to have
it so that whenever I double-click on the field ISBN in my form, it
will add the value to the end of
"http://www.amazon.com/exec/obidos/ASIN/" (so that, for example, I
have "http://www.amazon.com/exec/obidos/ASIN/0782123260") then launch
Internet Explorer and load that page.
Thanks in advance, Mike
Click to expand...

Const conAmazon As String = "http://www.amazon.com/exec/obidos/ASIN/"

Application.FollowHyperlink conAmazon & Me.ISBN
 
Dear Dirk,
Thanks--this works brilliantly!
Mike

Dirk Goldgar said:
MiniMike said:
I created a database for my book collection. One of the fields is the
ISBN of the book. Amazon.com has a product page for every book by
going to http://www.amazon.com/exec/obidos/ASIN/[ISBN].
Therefore what I'm trying to do and can't figure out how is to have
it so that whenever I double-click on the field ISBN in my form, it
will add the value to the end of
"http://www.amazon.com/exec/obidos/ASIN/" (so that, for example, I
have "http://www.amazon.com/exec/obidos/ASIN/0782123260") then launch
Internet Explorer and load that page.
Thanks in advance, Mike
Click to expand...

Const conAmazon As String = "http://www.amazon.com/exec/obidos/ASIN/"

Application.FollowHyperlink conAmazon & Me.ISBN

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Back
Top