How to design html report from vb

[sarup_24]

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.

[CHAMPGARY]

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

[sarup_24]

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.

[Bombdrop]

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.

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!!

[sarup_24]

Thanks Bombdrop.. Thanks for the nice function.