Get Field Names for an Access 2003 table

If I'm walking a record - field by field - using the .Fields(index) method is it also possible to pick up the field name at the same time?.
AdlermAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
peter57rConnect With a Mentor Commented:
Hello Adlerm,

.fields(index).name

Pete
0
 
MrAdrianTaylorCommented:

dim fld as dao.field

For Each fld In rs.Fields
       debug print fld.Name
       debug.print fld.value
next

rgds, Adrian
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.