Function RecordsetToTable(rs) 'As String Dim strTable Dim intField 'As Integer Dim strBrowserType 'As String If Not(rs.EOF And rs.BOF) Then rs.MoveLast rs.MoveFirst 'First send out the column headers strTable = "" & vbCrLf & "" For intField = 0 to rs.Fields.Count - 1 strTable = strTable & "" Next strTable = strTable & "" & vbCrLf 'Now send out the table body Do until rs.EOF strTable = strTable & "" For intField = 0 to rs.Fields.Count - 1 strTable = strTable & "" Next strTable = strTable & "" & vbCrLf rs.MoveNext Loop strTable = strTable & "
" & rs.Fields(intField).Name & "
" & rs.Fields(intField).Value & "
" RecordsetToTable = strTable Else RecordsetToTable = "" End If End Function