Publishing a report in HTML

[fyrewall]

Hi all,

I'm new to HTML and web development and have been asked if it is possible to publish an Access report on a browser.

I've created the report in Access '97 and it looks fine. Everything is lined up and I'm using the OnFormat property of the detail section to change the colour of a field depending on the value of another field.

When I Export To HTML, I lose my lines, the columns no longer line up and the report is black and white.

Can anyone help me with this please....??

Many Thanks

FyreWall

 

[RYankowitz]

My experience with this has been the same as yours. Access's HTML exporting does not appear to handle the commonly used report formatting attributes such as lines and boxes. And, while relative spacing between elements is preserved, expecting exact results is futile.

Microsoft's suggestion is to save the report in their 'Snapshot' format. The problem there is the user at the other end must download and install the Snapshot viewer, which is a good sized program (around 1.8 mB, if I remember correctly), and a bit of a pain to do.

Another solution (this one costs $$$) is to buy a copy of Adobe Acrobat, which can take the report and generate a .pdf file. The difference between the Adobe and Microsoft solutions is that Adobe has already succeeded in taking over the world in this area - just about everyone already has a copy of the Acrobat reader on their machines.

 

[CarlyA]

I had the same problem. Everybody complained about not having the lines, boxes, and other aesthetics on the report. I never considered generating a pdf file but I'm going to do that right now. In the meantime - I used color to differeniate between label names and data, etc.

 

[nickperez22]

I would like to create a button to export a report in Html by either creating a macro or coding it directly. When I export the report manually I don't see anywhere to save the export specification as you get when you export a table or query.

How can this be done?