How do I geta hyperlink when using asp and displaying data from Ac

[Guest]

I have created a Access database and am able to display data from the
database through my web page. Access has the ability to hyperlink a cell to
some other file, however when this cell is displayed on the web page, it
returns the text (URL) from the hyperlink. How do I get the hyperlink to show
properly on the web page?

 

[Murray]

As far as I know, you don't. I never use the hyperlink format in Access. I
just enter my link as plain text, and make it a hyperlink on the page
itself....

 

[Guest]

But that defeats one of the main reasons to use Access - to display your data
without having to rebuild the page every update - ie; you can update the
Access database and the page gets built automatically.

Perhaps there is a better(easier) way to do this. What I want to do is to
display rows of information about projects. One of the rows will have a
"Report" column which is hyperlinked to the report for more detail
information. The information (and hyperlink) already exists in Access (for
other reasons) - I would like to display this information on a web page
(without manually rebuilding the web page every time).

Any suggestions?

 

[Thomas A. Rowe]

However, Access the application is not actually running on the web server, so functions that you can
do in Access on the desktop do not work on the web.

If you design the display page correctly, you will not have to re-build it. Example

<a href="<%=recordset("Report")%>.asp"><%=recordset("Report")%> Details</a>

will give a hyperlink to "Report.asp" with a link name of "Report Details" on your page.

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

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

 

[Murray]

But that defeats one of the main reasons to use Access - to display your

data
without having to rebuild the page every update - ie; you can update the
Access database and the page gets built automatically.

How do you figure that?

I have on my pages this code -

<a href="<%=(rsSites.Fields.Item("SiteURL").Value)%>" target="_blank"><img
src="sites/<%=(rsSites.Fields.Item("ImageName").Value)%>" width="108"
height="108" alt="<%=(rsSites.Fields.Item("SiteName").Value)%>"
title="<%=(rsSites.Fields.Item("SiteName").Value)%>" border="0"></a>

Note that the hyperlink for the image, and the image source itself are both
being pulled from the database. Note also that I do NOT store the page -
just the filename, and the path is specified in the code - this way when I
change the path (if at all) I only have to modify that one line. Or maybe
that is what you are talking about?

If so, then it seems to me that it's still easier to change it on the HTML
page than it is to find every affected record and change it there. But
maybe I'm not getting your point.

 

[Murray]

Oops - "do NOT store the page" should be "do NOT store the path".

 

[Guest]

OK - I am somewhat inexperienced in writting html - but I think I see what
you both are saying .... thanks for the quick reply.

 

[Murray]

You're welcome.

--
Murray

OK - I am somewhat inexperienced in writting html - but I think I see what
you both are saying .... thanks for the quick reply.