John Bartow
john at winhaven.net
Fri Jul 27 16:40:44 CDT 2007
Hi Eric, I guess I'm not after quite the same thing as Steve (so sorry I chimed in on your thread Steve, I'll rename mine). I had tried something of this sort with A97 and it didn't work. Now obviously things have changed a lot since then but could you please elaborate a bit on this. What I wish to do is to run a process that creates static html pages from data stored in the database and places them into a folder (which is used by FrontPage). There two approaches I have considered: Write out a text file and use FP VBA to manipulate it into using the default css theme. Or (since I know the css tags) embed the tags directly into the data output from Access. (I would prefer this as I have no desire to learn FP's object model, as it is a dead horse now). I was thinking (hoping, really) that I could do this with a report and use labels (or eventually a lookup table and text fields) to embed the html/css code. I would then output these reports to the folder of choice using the windows generic text only printer. Any thoughts on this? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Eric Barro Sent: Friday, July 27, 2007 4:17 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Creating HTML file Steve, Grab any HTML editor that generates HTML (preferably drag and drop) and design your page and save it as an HTML file. And then you can open it with Notepad and use the generated HTML source code. Eric -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel Sent: Friday, July 27, 2007 2: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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com