![]() |
#2
xss_wl2016-11-09 11:35
|
MSHFlexGrid1 表格中怎么显示为下面单选框
只有本站会员才能查看附件,请 登录
我的现在显示为
只有本站会员才能查看附件,请 登录

Private Sub Command1_Click()
Call OpenConn
sql = "SELECT iif(审核标志=-1,'是','否') as 审核标志 from 发票 WHERE 户号 = '" & Text1.Text & "'"
rs.Open sql, cn, 3, 3
If rs.RecordCount = 0 Then
MsgBox "无此记录,请重新输入!", 32, "系统"
Text1.Text = ""
Else
If rs.RecordCount > 0 Then
Set MSHFlexGrid1.DataSource = rs
End If
End If
CloseConn
End Sub
Call OpenConn
sql = "SELECT iif(审核标志=-1,'是','否') as 审核标志 from 发票 WHERE 户号 = '" & Text1.Text & "'"
rs.Open sql, cn, 3, 3
If rs.RecordCount = 0 Then
MsgBox "无此记录,请重新输入!", 32, "系统"
Text1.Text = ""
Else
If rs.RecordCount > 0 Then
Set MSHFlexGrid1.DataSource = rs
End If
End If
CloseConn
End Sub
现在能显示是/否,但是MSHFlexGrid1就这一列数据
只有本站会员才能查看附件,请 登录
[此贴子已经被作者于2016-11-9 00:37编辑过]