Usual < problem

  • Thread starter Thread starter Simon Weaver
  • Start date Start date
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
 
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)
|/---------------------------------------------------
*----------------------------------------------------
 
Sorry Jim, your reply was marked 'Message Unavailable'

Can you repeat it?

TIA, Simon
 
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...
 
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)
|/---------------------------------------------------
*----------------------------------------------------
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

&lt; Clarity 3
Jim &lt; 2
Find all href from a html file 10
Server.HtmlDecode Question 2
HTML reformat bugs in <pre> and anchors (FrontPage 2003) 1
Problems with Front Page 2002 3
@ my wits end 1
Replace email 1

Back
Top