[AccessD] Creating HTML file

Drew Wutka DWUTKA at Marlow.com
Sat Jul 28 19:55:25 CDT 2007


I know I'm late to the party on this, but why must it be a static web
page.  Making dynamic pages with asp is a snap.  Create the HTML in any
editor you want.  Then save it as an ASP page.

<%
Dim cnn
Dim rs
Dim strSQL
Set cnn=server.createobject("ADODB.Connection")
Set rs=server.createobject("ADODB.Connecion")
strSQL="Your SQL string to get the data...
'Then connect the cnn, and open the recordset
%>

You now have a recordset open in asp.  To use this, you can just put asp
in the middle of the HTML.

For example, if you have:

<p>The current value is 1</p>

And you want to make that 1 a value from your recordset:

<p>The current value is <%=rs.fields("NumericValue").value%></p>

Whalla.  You can also do conditional formatting:

<% if rs.fields("SomeField").value="SomeValue"%>
<p>Some paragraph in the HTML document</p>
<%else%>
<p>Some other paragraph</p>
<%end if%>

You can also loop this way, for example, if you want a table with your
data:

<table width="100%">
<%Do until rs.EOF=True%>
	<tr>
		<%For i=0 to 4 'just assuming 5 fields%>
			<td width="20%"><%=rs.fields(i).Value%></td>
		<%next%>
	</tr>
	<%rs.movenext%>
<%loop%>
</table>
	
You mentioned Frontpage, one of the handy things about Front page is
that if you select something in the 'design view', when you switch to
the HTML view, the HTML of the selected area will be highlighted too.

Drew
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Friday, July 27, 2007 4:04 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Creating HTML file

Hi.  I am just about to do something I have never tried before.  I need 
to create a static web page from Access data.  Using OutputTo from a 
report has too many problems.  Using DoCmd.TransferText acExportHTML 
doesn't give me the formatting flexibility that I need.  Therefore I've 
decided to try to loop through a recordset and build the html file in 
code.  Main problem being that my html skills are minimal.  Has anyone 
done this type of thing?  Any tips?  Thanks.

Regards
Steve
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI BusinessSensitve material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.





More information about the AccessD mailing list