accsee里的空记录,取出来,放在MSFlexGrid里。调试时,老是有这个错误,实时错误‘94’无效使用 NULL。各位帮帮忙了。
解决方案 »
- MSComm1.PortOpen = True报错
- 关于图像框的问题。。。
- 如何利用api向其他窗口(程序)发送键盘消息?
- 随窗体变 按扭大小不变 位置改变
- 关于MSComm1的问题,我在两个窗体form1和form2中用到了MSComm1控件,如果我在关闭form1后马上打开form2的时候,会出现端口已打开的错误报
- 各位大虾:如何向程序中传递参数?(在线等候)
- Win2K下怎样编程屏蔽打印端口?
- vb打包时,这个文件(MDAC_TYP.EXE)是不是一定要?这个文件好大啊
- 我的 ado 类库是时期的2.1 library,如何搞到2.6 版.
- mshflexgrid的bug????
- 怎样让Text框输入的只能是数字,小数点后面最多两位啊
- 如何取出A表中在B表中没有的记录?
msflexgrid=rs!id & "" '就是在后面加个空符就不会有NULL了
With Me.MSFlexGrid1
.Rows = 1
While Not rst.EOF
.Rows = .Rows + 1
.TextMatrix(.Rows - 1, 0) = rst(0)
.TextMatrix(.Rows - 1, 1) = rst(1)
.TextMatrix(.Rows - 1, 2) = rst(2)
.TextMatrix(.Rows - 1, 3) = rst(3)
rs.MoveNext
Wend
End With
Loop
rs.CloseEnd Sub
我语句是这样写的,哪里写错了!
set msflexgrid.datasource=rs
end if
With Me.MSFlexGrid1
.Rows = 1
While Not rst.EOF
.Rows = .Rows + 1
.TextMatrix(.Rows - 1, 0) = iif(isnull(rst(0))," ",rst(0))
.TextMatrix(.Rows - 1, 1) = iif(isnull(rst(1))," ",rst(1))
.TextMatrix(.Rows - 1, 2) = iif(isnull(rst(2))," ",rst(2))
.TextMatrix(.Rows - 1, 3) =iif(isnull(rst(3))," ",rst(3))
rs.MoveNext
Wend
End With
Loop
rs.CloseEnd Sub
on error resume next
With Me.MSFlexGrid1
.Rows = 1
While Not rst.EOF
.Rows = .Rows + 1
.TextMatrix(.Rows - 1, 0) = iif(isnull(rst(0))," ",rst(0))
.TextMatrix(.Rows - 1, 1) = iif(isnull(rst(1))," ",rst(1))
.TextMatrix(.Rows - 1, 2) = iif(isnull(rst(2))," ",rst(2))
.TextMatrix(.Rows - 1, 3) =iif(isnull(rst(3))," ",rst(3))
rs.MoveNext
Wend
End With
Loop
rs.CloseEnd Sub
.TextMatrix(.Rows - 1, 1) = rst(1) & ""
.TextMatrix(.Rows - 1, 2) = rst(2) & ""
.TextMatrix(.Rows - 1, 3) = rst(3) & ""
一个一个格写太慢了
你的那个错误与表格应该没关系,是因为你引用了一个null值产生的
.TextMatrix(.Rows - 1, 1) = iif(isnull(rst(1))," ",rst(1))
.TextMatrix(.Rows - 1, 2) = iif(isnull(rst(2))," ",rst(2))
.TextMatrix(.Rows - 1, 3) =iif(isnull(rst(3))," ",rst(3))就这个最好了
.TextMatrix(.Rows - 1, 1) = iif(isnull(rst(1))," ",rst(1))
.TextMatrix(.Rows - 1, 2) = iif(isnull(rst(2))," ",rst(2))
.TextMatrix(.Rows - 1, 3) =iif(isnull(rst(3))," ",rst(3))
.TextMatrix(.Rows - 1, 1) = "" & rst(1))
.TextMatrix(.Rows - 1, 2) = "" & rst(2))
.TextMatrix(.Rows - 1, 3) = "" & rst(3))
有文件介绍用IIF慢
With Me.MSFlexGrid1
.Rows = 1
While Not rst.EOF
.Rows = .Rows + 1
.TextMatrix(.Rows - 1, 0) = rst(0) & “” '后面加个空字符串就好了
.TextMatrix(.Rows - 1, 1) = rst(1) & “”
.TextMatrix(.Rows - 1, 2) = rst(2) & “”
.TextMatrix(.Rows - 1, 3) = rst(3) & “”
rs.MoveNext
Wend
End With
Loop
rs.CloseEnd Sub
.col=1
.text=Trim(Rs("Name") & "")
end with
.Row = 1
Do While Not mrc.EOF
.Rows = .Rows + 1
For i = 1 To mrc.Fields.Count
.TextMatrix(.Row, i) = mrc.Fields(i - 1) & "" '后面加个空字符串
Next i
.Row = .Row + 1
mrc.MoveNext
Loop
End With
MSFlexGrid1.TextMatrix(i, j) = "<NULL>"
Else
MSFlexGrid1.TextMatrix(i, j) = rs.Fields(rs.Fields(j - 1).Name).Value
End If
strSearchResult(iCount, i) = ""
Else
strSearchResult(iCount, i) = rs(i - 1)
End If
If IsNull(rs(i - 1)) Then
strSearchResult(iCount, i) = ""
Else
strSearchResult(iCount, i) = rs(i - 1)
End If