我找到了 For intloop = 0 To rstEmployees.Fields.Count - 1 Debug.Print " " & rstEmployees.Fields(intloop).Name Next intloop
你认为这两种方式有什么两样吗? dim fie as field for each fie in tabname.fields debug.print fie.name next fie '____________________________________ For intloop = 0 To rstEmployees.Fields.Count - 1 Debug.Print " " & rstEmployees.Fields(intloop).Name Next intloop
呵呵,那么你可以这样: dim fie as field for each fie in rstEmployees.fields debug.print fie.name next fie '____________________________________ For intloop = 0 To rstEmployees.Fields.Count - 1 Debug.Print " " & rstEmployees.Fields(intloop).Name Next intloop
这两段不是一样吗,我只所以不用 dim fie as field for each fie in tabname.fields debug.print fie.name next fie 是因为还要定义tabname 好了,我可以结了,分都给你吧
For intloop = 0 To rstEmployees.Fields.Count - 1
Debug.Print " " & rstEmployees.Fields(intloop).Name
Next intloop
dim fie as field
for each fie in tabname.fields
debug.print fie.name
next fie
'____________________________________ For intloop = 0 To rstEmployees.Fields.Count - 1
Debug.Print " " & rstEmployees.Fields(intloop).Name
Next intloop
dim fie as field
for each fie in rstEmployees.fields
debug.print fie.name
next fie
'____________________________________ For intloop = 0 To rstEmployees.Fields.Count - 1
Debug.Print " " & rstEmployees.Fields(intloop).Name
Next intloop
dim fie as field
for each fie in tabname.fields
debug.print fie.name
next fie
是因为还要定义tabname
好了,我可以结了,分都给你吧