Report to HTML without Wizard

[Telsa]

I need to generate HTML code from a report without using the Wizard (it does a lousy job).&nbsp;&nbsp;I can write the code create the tags and such in a module but am not sure how to call the report into the VBA code.&nbsp;&nbsp;<br><br>If I really knew how it did it from my query, guess I could replicate that.&nbsp;&nbsp;I'm using cross tabs in my query, which may make things more difficult.<br><br>Anybody have any ideas/suggestions how to go about this?<br><br>Thanks!<br><br>Mary )

 

[DougP]

I suspect if you are writing your own HTML page that you would just write VBA code to open the datasource the same as your report.<br>In other words leave your report out all together.<br>What is the data source of the report a query or something?<br>Now if you need to see a visual of the report there is code to launch IE and display your new HTML report instead.<br><br>See rumor has it that applications as we know them will merge into one big Internet thingy.<br>So instead of having an Access report or even an Access form you'll have .html for rteports and .asp pages as forms. Then each person does not have to have Access.<br>but that a way's off yet.<br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[Telsa]

The report is created from a crosstab query.&nbsp;&nbsp;In addition, I will be adding summaries of the columns and grand total, which obviously the query can't do.&nbsp;&nbsp;<br><br>I was hoping to find the code that generates the report and duplicate it in my module and then put HTML tags around it.<br><br>The report will be part of another HTML section.&nbsp;&nbsp;SO it needs to be an independent file.&nbsp;&nbsp;NO big deal, I did it before with another query... but it wasn't a crosstab and I didn't need summaries in it!&nbsp;&nbsp;That is where the challenge comes in!<br><br>I'm still learning ASP but haven't gotten to the part about connecting databases and generating tables from it yet.<br><br>Thanks!<br><br>Mary )<br><br>Thanks!<br><br>