Going to URL Interesting Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MiniMike - 17 Mar 2005 08:51 GMT

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

Reply to this Message

JaRa - 17 Mar 2005 14:13 GMT

You could try it this way

Shell "explorer http://www.amazon.com/exec/obidos/ASIN/0782123260"

- Raoul

> 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
[quoted text clipped - 5 lines]
> launch Internet Explorer and load that page.
> Thanks in advance, Mike

Reply to this Message

Dirk Goldgar - 17 Mar 2005 17:05 GMT

> 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
[quoted text clipped - 6 lines]
> Internet Explorer and load that page.
> Thanks in advance, Mike

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

Application.FollowHyperlink conAmazon & Me.ISBN

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

MiniMIke - 17 Mar 2005 19:47 GMT

Dear Dirk,
Thanks--this works brilliantly!
Mike

> > 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
[quoted text clipped - 10 lines]
>
> Application.FollowHyperlink conAmazon & Me.ISBN

Reply to this Message