Max Wanadoo
max.wanadoo at gmail.com
Mon Sep 28 15:39:39 CDT 2009
Thank you Drew. Much appreciated.
Max
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: 28 September 2009 21:10
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access to Web
Just make sure IIS is installed. It'll need to be setup as a web page
in the webserver. I've posted about this in the past, way to long to
get into today. But an ASP page needs to be 'opened' through a
webserver, not just by the browser. In other words, with a plain html
page, you could go 'C:\WebFolder\MyFile.html' OR
'http://localhost/MyFile.html' and your browser would open the file. In
the first instance, it's just opening it from your hard drive, in the
second instance, it is querying you local webserver and displaying the
page handed to it. So with an asp page, only the second instance will
work right.
Here is an example of an ASP page that would display a recordset as a
table:
<html>
<head>
<title>SQL Statement Processing</title>
</head>
<body>
<br><br>
<%
Dim cnn
dim sql
dim rs
dim i
dim strResp
set cnn=server.createobject("ADODB.Connection")
set rs=server.createobject("ADODB.Recordset")
cnn.Provider="Microsoft.Jet.OLEDB.4.0"
cnn.open "c:\yourdatabase.mdb"
rs.open "SELECT ....",cnn,1,1
<table width="100%" border=1>
<tr>
<%for i=1 to rs.fields.count%>
<td
width="<%=(100/rs.fields.count)%>%"><%=rs.fields(i-1).Name%></td>
<%next%>
</tr>
<%if rs.eof=false then
rs.movefirst
do until rs.eof=true%>
<tr>
<%for i=1 to rs.fields.count%>
<td
width="<%=(100/rs.fields.count)%>%"><%=rs.fields(i-1).value%></td>
<%next%>
</tr>
<%
rs.movenext
loop%>
<%end if%>
</table>
<%rs.close
set rs=nothing
cnn.close
set cnn=nothing
%>
</body>
</html>
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Sunday, September 27, 2009 4:14 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access to Web
Yes please Drew. What do I need installed on the PC to run it?
Max
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: 27 September 2009 08:56
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access to Web
Max, I can dig up some very simple asp (classic) code that takes a query
and displays the result. Very, VERY simple.
Drew
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Friday, September 25, 2009 10:53 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access to Web
Stuart:
Wow, that must have taken a whole lot of time to hand-craft those
sites.
They look very good.
I have done similar (but not to this standard) and that is what I wanted
to
try and avoid - I was wondering if there was a HTML generator from data
fields somewhere.
I didn't want to export to excel and the save from excel. I was hoping
to
give the users a one-stop-click button and voila, up comes the web page.
I
do this at the moment with hand-rolled code.
Max
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: 25 September 2009 22:44
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access to Web
You can save a report as HTML, but it generates really crappy HTML.
I've got some failry sophisticated systems that create tables on web
pages
and it's all hand
rolled code.
Take a look at the real estate listings at
http:///www.sre.com.pg
or the job listings at http://www.vanguardpng.com
The dynamic pages, plus the "featured properties" on the SRE front page
are
all generated
by VBA procedures.
--
Stuart
On 25 Sep 2009 at 7:34, Max Wanadoo wrote:
> Is there an easy way to get access data onto a web page.
> 1. via excel
> 2. via pdf and then pdf to web.
> 3. Hard coding
>
> Anything better?
> Thanks
> Max
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
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
Business
Sensitive 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.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
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
Business
Sensitive 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.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com