Solved

Get Field Names for an Access 2003 table

Posted on 2004-10-21
2
158 Views
Last Modified: 2006-11-17
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
Comment
Question by:Adlerm
2 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 50 total points
ID: 12368067
Hello Adlerm,

.fields(index).name

Pete
0
 
LVL 1

Expert Comment

by:MrAdrianTaylor
ID: 12371944

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question