Number of fields in recordset

[ddrandy]

I have connected to an access database and I would like to contruct an update statement into another database. Without specifing the specific fields, I would like to user the fields attribute to get the name of the field (rec.fields(0).name) and the value (rec.fields(0)). My question is, How do I know how many fields are in my table so I can create a loop to do this?

Thanks

 

[Swi]

rs.Fields.Count

Swi

 

[fredericofonseca]

using ADO
dim rs as recordset
...

rs.fields.count will give you the number of fields.

you can then loop through the fields

for i = 1 to rs.fields.count (maybe zero based)
s = rs.fields(i).value
name = rs.fields(i).name
next i

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com