应该没有呀,我的代码如下:
If Check1.Value = 1 Then
If Trim(CBSSHY.Text) = "" Then
MsgBox "请选择查询条件!", vbOKOnly + vbExclamation, "系统提示"
CBSSHY.SetFocus
Exit Sub
Else
strsql = "select xxbh,gsdw,fbrq,sshy from zpxx where sshy='" & Trim(CBSSHY.Text) & "'order by xxbh"
Frm_zpxx.Adodc1.RecordSource = strsql
Frm_zpxx.Adodc1.Refresh
Call showTitle〈----------------------------|
Frm_zpxx.MSHFlexGrid1.Refresh |
Unload Me |
End If |
End If |
Private Sub showTitle()〈-------------------------|
Dim i As Integer
Dim l As Integer
Dim cRowColor(1) As OLE_COLOR
With Frm_zpxx.MSHFlexGrid1
.Cols = 3
'列宽
.TextMatrix(0, 0) = "信息编号"
.TextMatrix(0, 1) = "公司/单位名称"
.TextMatrix(0, 2) = "发布日期"