How to design html report from vb

Hi..
How do I design a html report from visual basic 6.0? The report will consist of tables with values from a access database.

Thanks for you time. :)

Hi sarup_24,

I have one pretty example of datareport.Downloaded from forum. ;)
See the attachment , I am sure this will help you a lot :)

Hi..

Thanks a lot.
I got some idea..but I want to have some control on the design of the html output...I have many tables of data in access and I want them to display in a single html file.

Please help me.

Thanks.

Try this little function i think this is what you are after, well it will need a bit more work but it's a start.

Code:

---

Public Function RStoHTML(rs As ADODB.Recordset) As String
   
    RStoHTML = rs.GetString(adClipString, -1, "</TD><TD>", _
                "</TD></TR>" & vbCrLf & "<TR><TD>", "(NULL)")
               
    RStoHTML = "<TR><TD>" & Left(RStoHTML, Len(RStoHTML) - 8)
   
    RStoHTML = "<TABLE> " & RStoHTML & "</TABLE>"
   
End Function

---

Hope this helps!!
:wave: :thumb: :wave:

Thanks Bombdrop.. Thanks for the nice function.