我把Rows的值设为2行,一行固定行,下面这段程序,如果Myrs中只有唯一一条数据就没有错误,如果不只一条就提示TextMatrix(r, i)越界,而且好象无论Myrs.RecordCount的值是多少,Rows永远都是2,郁闷ing…… With MSFlexGrid1
.Rows = (Myrs.RecordCount + 1)
r = 1
Do While Not Myrs.EOF
For i = 1 To Myrs.Fields.Count
.TextMatrix(r, i) = Trim(Myrs.Fields(i - 1))
Next i
r = r + 1
Myrs.MoveNext
Loop
End With
.Rows = (Myrs.RecordCount + 1)
r = 1
Do While Not Myrs.EOF
For i = 1 To Myrs.Fields.Count
.TextMatrix(r, i) = Trim(Myrs.Fields(i - 1))
Next i
r = r + 1
Myrs.MoveNext
Loop
End With
解决方案 »
- 大家看看我这段VBS脚本代码那里有错误?
- 现有两个表a(消费合计),b(消费记录)要把b中的“消费明细”的合计赋值给a中的“消费合计”,即a中的“id”等于b中的“id”
- 复杂的自动编号求助!!!!!!!!!急!急!急!
- 关于Crystal Reports的一个问题
- 请问如何做到某Lable为空时禁用某按钮,有内容时启用?
- 继续狂送100分(2)
- 在查询数据时,要转到第几条记录,该怎么做?
- 简单的问题!SQL查询
- 请推荐一本结合VB讲解WMI的优秀教材。谢谢!
- 在ACCESS数据库中添加一个新表,为什么不能用中文??
- ADO连接ORACLE的很奇怪的问题?帮忙看看,在线等...谢
- 散分 恭喜成立VB COM/DCOM/COM+版
例如rows的默认值为10, Myrs.RecordCount 为5就正常。
.Rows = (Myrs.RecordCount + 1)
r = 1
Do While Not Myrs.EOF
For i = 0 To Myrs.Fields.Count - 1
.TextMatrix(r, i) = Trim(Myrs.Fields(i))
Next i
r = r + 1
Myrs.MoveNext
Loop
End With
.TextMatrix(r, i) = Trim(Myrs.Fields(i))
Next i
可能他没取出正确的数值来!!
With MSFlexGrid1
.Rows = (Myrs.RecordCount + 1)
r = 1
Myrs.movefirst
Do While Not Myrs.EOF
For i = 1 To Myrs.Fields.Count
.TextMatrix(r, i) = Trim(Myrs.Fields(i - 1))
Next i
r = r + 1
Myrs.MoveNext
Loop
End With
with MSFlexGrid1
.Rows=1
Do While Not Myrs.EOF
strdata=""
For i = 0 To Myrs.Fields.Count-1
strdata=strdata & Trim(Myrs.Fields(i - 1)) & iif(i=Myrs.Fields.Count-1,"",chr(9))
Next i
.AddItem strdata
Myrs.MoveNext
Loop
end with
rs.movenext
最後就取出來了呀
cnns.CursorLocation =adUseClient
rs.Open sql,cnns,adOpenForwardOnly ,adLockReadOnly