Creating hyperlinks into and out of MS Access Database

[stevepugh]

Hi All,

I want to be able to create a very simple web based input form so that i can insert a web address, hit submit, and send this to an MS access database which in turn sends the data to a 'links' page on my web site.

I have tried making the field in the database 'hyperlink' but all this does is make the content of the field a hyper link. Once it is sent to the web page it no longer functions as a hyperlink.

There has to be a way of doing this but I can't figure it out.

Please help.:eek:

[yamaharuss]

you need to output the data as a lnk

<a href="<%=rs("yourlink")%>">click here to visit <%=rs("yourlink")%></a>

[stevepugh]

you need to output the data as a lnk

<a href="<%=rs("yourlink")%>">click here to visit <%=rs("yourlink")%></a>

Thanks for this. I was coming at it in completely the wrong direction.

Yamaharuss you are a star!