如何替代字段

youer_ma

我有一库,字段名为1,2,3.......50,在VBA中如何用一变量替代1,2,3.....50等,如reczd!=a(ii)[em24]

[此贴子已经被作者于2002-11-1 10:55:40编辑过]

Trynew

用DAO的RecordSet.Fields对象

youer_ma

谢谢,可RecordSet.Fields怎么用,帮助中找不到

Trynew

要先引用DAO,查找DAO的帮助
dim db as database
dim rst as recordset
dim i as integer
set db=currentdb()
set rst=db.openrecordset("TableName")
for i=0 to rst.fields.count-1
    msgbox rst.fields(i).name
next