How to create a clickable link on a data results page from an access database

  • Thread starter Thread starter Dave M
  • Start date Start date
D

Dave M

I have a hyperlink field in a Microsoft Acesss Database
that I'm displaying on a database results form. I want
the column displayed with 2004 December Newsletter that
is a clickable hyperlink to the Newsletter htm page. This
is the code that is generated on the database results
form. Does anyone know how to accomplish this in FrontPage
2003? What to the % and # chars mean in the code below?
Thanks in advanced

<p><a href="2004%20December%
20Newsletter#../newsLetters/lagernewsDec2004.htm#">2004
December
Newsletter#../newsLetters/lagernewsDec2004.htm#</a>
 
Make two fields in the database, both plain text.

Example

LinkTitle = 2004 December Newsletter
LinkURL = lagernewsDec2004.htm

Then in your code you would do

<a href="../newsLetters/<%=rs("LinkURL")%>"><%=rs("LinkTitle")%></a>


--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Back
Top