Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| docs:programming:office_vba:adodb_recordset [2007/07/13 12:00] – created billh | docs:programming:office_vba:adodb_recordset [2008/08/03 00:25] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== ADODB.Recordset ====== | ====== ADODB.Recordset ====== | ||
| - | Typical code to connect and process records | + | Typical code to connect and list field names in a table: |
| < | < | ||
| Public Sub ListFields() | Public Sub ListFields() | ||
| + | Dim rst As ADODB.Recordset | ||
| + | Dim fld As ADODB.Field | ||
| + | Set rst = New ADODB.Recordset | ||
| + | rst.Open " | ||
| + | For Each fld In rst.Fields | ||
| + | Debug.Print fld.Name | ||
| + | Next fld | ||
| + | rst.Close | ||
| + | Set fld = Nothing | ||
| + | Set rst = Nothing | ||
| End Sub | End Sub | ||
| </ | </ | ||