URL in a database

[Pat Hall]

Access 2002
I need to set up a form that can be used to enter a URL in a database.

I've got the field I want to use defined as an OLE Object.

If I paste a URL in the Hyperlink field, when I click on the link I don't go
to the specfic web page. I end up at a higher level page on the web site.
(Using Google Maps).

How do I do this?

 

[Dorian]

In a database I wrote, I have a table of web addresses (URLs). The column is
defined as text(100) and is called 'Link'.
On the page that allows following the link, my code does:

Me.butTest.HyperlinkAddress = Me!Link

A button (butTest) is pressed to follow the link and in the button's
GotFocus event, I set the hyperlinkaddress propertry to the value in the
column (Me!Link).
Hope this helps.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".