[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 185
  • Last Modified:

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?.
0
Adlerm
Asked:
Adlerm
1 Solution
 
peter57rCommented:
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now