Loop thru fields in a recordset

[GBGH]

Hi,

For each row of a recordset (based on a query), I need to loop through the fields and concatenate field values with delimiters for export into a text file. I can't use transfertext b/c different delimiters for last field.

Can one programmatically supply the field name to get the value of the field?

Gretchen

 

[SgtJarrow]

the following pseduo code should help you out:

' Move through all the records
rs.movefirst
Do until rs.eof
' loop through each field in the recordset
For i = 0 to (number of fields - 1, since field counts start at zero)
rs.fields(i) ' do whetever
Next i
Loop

****************************
When the human body encounters disease it raises its temperature making it uncomfortable not only for the body but also for the disease. So it global warming the Earth's way of saying we are not wanted?

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com