Data.Recordset.RecordCount这句话是有点不好使,
写一个sql于据判断具体循环次数,
data.recordsource = "select Count(*) from youtable"
data.refresh
Count = data.recordset.field(0).value
for i = 1 to Count
.....
next
写一个sql于据判断具体循环次数,
data.recordsource = "select Count(*) from youtable"
data.refresh
Count = data.recordset.field(0).value
for i = 1 to Count
.....
next
直接查找,不用去遍历整个表