Usual < problem

S

Simon Weaver

I've read some past posts from Stephan, Kathleen and Jim
Buyens regarding this problem, but have not found the
answer.

I am building an anchor tag in an Access query and trying
to output it as an html anchor when Exporting the query
as an html file.

The data in my Access table is a code i.e. AA1

I am trying to create a string like this

<a href=" '' &
Code: 
 & ''.htm" target="_blank">Amino
Acids</a>

So the string is interpreted as an anchor in the table.

Of course, the browser replaces the < with &lt;

How can I overcome this?

TIA, Simon
 
J

Jim Buyens

After the DRW completes:

1. Right-click teh column in question.
2. Choose Database Column Value properties.
3. Select Column Value Contains HTML.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
S

Simon Weaver

Sorry Jim, your reply was marked 'Message Unavailable'

Can you repeat it?

TIA, Simon
 
S

Simon Weaver

Sorry, I am not using a DRW - Exporting recordset to a
<TABLE>

I am Exporting an Access query (File, Export) and saving
as File Type HTML.

I want to format the code so that it appears as a
hyperlink, linking to suitalbly named html files.

Test Kit AA1
Test Kit BB1

Contents = AA1.htm
Contents = BB1.htm

TIA, Simon

PS, Newsgroup not working well tonight...
 
J

Jim Buyens

I'm not sure how to do that in Access. Perhaps someone on hte MS Access
newsgroup could help you.

FWIW, I would just write an ASP page that creates exactly the display you
want. Here's a simple example:

<%option explicit%>
<html>
<head>
<title>Category Query</title>
</head>
<body>
<table>
<tr>
<th>ID</th>
<th>Name</th>
<th>Description</th>
</tr>
<%
Dim cnNwind
Dim sql
Dim rsCats
Set cnNwind= Server.CreateObject("ADODB.Connection")
cnNwind.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & _
Server.MapPath("../fpdb/fpnwind.mdb") & ";"
sql = "SELECT * FROM categories"
Set rsCats = Server.CreateObject("ADODB.Recordset")
rsCats.Open sql, cnNwind
Do While Not rsCats.eof
%>
<tr>
<td><%=rsCats("CategoryID")%></td>
<td><%=rsCats("CategoryName")%></td>
<td><%=rsCats("Description")%></td>
</tr>
<%
rsCats.MoveNext
Loop
rsCats.Close
Set rsCats = Nothing
cnNwind.close
Set cnNwind = Nothing
%>
</table>
</body>
</html>

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
 
Top