RE: [Q] generating html from a database?

On Saturday, April 27, 1996, dedmunds_at_sfu.ca wrote...
>
> I'd like input on how easy/difficult it will be to create HTML documents
> from a relational database.
>

Darran,

I have Access 7.0 under Win 95. I upgraded from Win3.11 and Access 2.0 after discovering the following two bugs, confirmed by Microsoft's Help line:

1. Access 2.0 won't output subform records in a report when File|Save As/Export|To an External File or Database|Save as Type|TEXT FILES is selected.
2. Only the first line of Memo fields are put into the file using the method above.

Access 7.0 fixes these bugs, but has new ones:

1. Subform records are output to the file in groups of 3 followed by one blank line.
2. Label Controls containing the fixed HTML text in the report are sometimes truncated and strewn randomly throughout the file.

I've now moved to using the Visual Basic to write a module that uses Print #1, "html text here"; table!fieldhere; "more html" to output the database information embedded within html format strings. This does work.

John Morfit Received on Mon Apr 29 1996 - 00:00:00 CEST