Option ExplicitPrivate Sub Combo1_Click()
Text1.Text = ""
Text1.SetFocus
Select Case Combo1.TextCase "按身份证号"
Label3.Caption = "如:42015689851565"
Case "按姓名"
Label3.Caption = ""
Case "按出生日期"
Label3.Caption = "如:1999-9-8"
Case "按籍贯"
Label3.Caption = ""
Case "按性别"
Label3.Caption = ""
End Select
End SubPrivate Sub Command1_Click()
Set rs = New ADODB.Recordset
Select Case Combo1.Text
Case "按姓名"
CString = "huzhuming='"
Case "按性别"
CString = "xingbie='"
Case "按身份证号"
CString = "shengfenhao='"
Case "按出生日期"
CString = "shengri='"
Case "籍贯"
CString = "jiguan='"
End Select
CString = CString & Trim(Text1.Text) & "'"
rs.Open "select * from HUJI-3 where " & Trim(CString), conn, adOpenStatic, adLockReadOnly
If rs.RecordCount <> 0 Then
MSHFlexGrid1.Visible = True
Set MSHFlexGrid1.DataSource = rs
Text1.Text = ""
Text1.SetFocus
Else
MSHFlexGrid1.Visible = False
MsgBox "没有此记录"
Text1.Text = ""
Text1.SetFocus
End If
End SubPrivate Sub Command2_Click()
Unload Me
Load hecaozuo3
hecaozuo3.Show
End SubPrivate Sub Form_Load()
Label5.Left = (Me.ScaleWidth - Label5.Width) / 2
Label5.Top = 200
End Sub系统提示 Private Sub Command1_Click()
Set rs = New ADODB.Recordset
rs变量未定义,请求帮助修改!如果还有其他问题请一并帮忙指出,谢谢!!!
Text1.Text = ""
Text1.SetFocus
Select Case Combo1.TextCase "按身份证号"
Label3.Caption = "如:42015689851565"
Case "按姓名"
Label3.Caption = ""
Case "按出生日期"
Label3.Caption = "如:1999-9-8"
Case "按籍贯"
Label3.Caption = ""
Case "按性别"
Label3.Caption = ""
End Select
End SubPrivate Sub Command1_Click()
Set rs = New ADODB.Recordset
Select Case Combo1.Text
Case "按姓名"
CString = "huzhuming='"
Case "按性别"
CString = "xingbie='"
Case "按身份证号"
CString = "shengfenhao='"
Case "按出生日期"
CString = "shengri='"
Case "籍贯"
CString = "jiguan='"
End Select
CString = CString & Trim(Text1.Text) & "'"
rs.Open "select * from HUJI-3 where " & Trim(CString), conn, adOpenStatic, adLockReadOnly
If rs.RecordCount <> 0 Then
MSHFlexGrid1.Visible = True
Set MSHFlexGrid1.DataSource = rs
Text1.Text = ""
Text1.SetFocus
Else
MSHFlexGrid1.Visible = False
MsgBox "没有此记录"
Text1.Text = ""
Text1.SetFocus
End If
End SubPrivate Sub Command2_Click()
Unload Me
Load hecaozuo3
hecaozuo3.Show
End SubPrivate Sub Form_Load()
Label5.Left = (Me.ScaleWidth - Label5.Width) / 2
Label5.Top = 200
End Sub系统提示 Private Sub Command1_Click()
Set rs = New ADODB.Recordset
rs变量未定义,请求帮助修改!如果还有其他问题请一并帮忙指出,谢谢!!!
解决方案 »
- VB报错,无效的过程调用或参数,急急急!
- MScomm关于‘8002’无效端口号
- 哪种网上银行业务能查看客户给我汇款的信息,如汇款金额、汇款帐号、汇款者姓名等
- ini文件的作用?
- 关于Excel单元格数据类型的问题,百思不得其解 :(
- 有经验的程序员请指教?(一定是有经验的程序员回答)
- 寻求方法!
- 数据库问题求教!!!!
- vb操作txt中的数据,按行在vsflex中显示,怎样才能合并内容相同的行呢?求助,谢谢
- 关于internet transfer控件
- 如何在DataGrid中选中一条记录,然后用程序将其在数据库中删除
- 请问如何触发mscomm控件的oncomm事件?是否只要将我的设备(例如MODEM或GPS)与计算机连线即可?
Dim Rs As ADODB.Recordset
Set rs = New ADODB.Recordset
合为一句:
Dim Rs As New ADODB.Recordset
改为Dim Rs as new adodb.RecordSet就OK了