• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• DAOTableToHTML

DAOTableToHTML

Convert a database table to HTML

Inputs
DAO Recordset Object

Assumes
A reference to DAO x.x Object Library

Returns
String

Rate DAOTableToHTML

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

Const T1 = vbTab
Const T2 = T1 & T1
Const TR = T1 & ""
Const TD = ""
Const TDEND = ""
Const TABLESTART = ""
Const TABLEEND = ""
Function HTMLTable(dbRecord As Recordset) As String
Dim strReturn As String
Dim Fld As Field
On Error GoTo Return_Zero
strReturn = strReturn & TABLESTART & vbCrLf
strReturn = strReturn & TR
For Each Fld In dbRecord.Fields
  strReturn = strReturn & TD & Fld.Name & TDEND
Next Fld
strReturn = strReturn & vbCrLf
dbRecord.MoveFirst
While Not dbRecord.EOF
  strReturn = strReturn & TR
  For Each Fld In dbRecord.Fields
    strReturn = strReturn & TD & Fld.Value & TDEND
  Next Fld
  strReturn = strReturn & vbCrLf
dbRecord.MoveNext
Wend
strReturn = strReturn & TABLEEND
Return_Zero:
HTMLTable = strReturn
End Function