vb中变量未设置或是with变量未设置

来源:百度知道 编辑:UC知道 时间:2024/05/21 23:00:58
Private Sub cmdOK_Click()
'ToDo: create test for correct password
'check for correct password
Dim txtSQL As String
Dim mrc As ADODB.Recordset
Dim MsgText As String
'ToDo: create test for correct password
'check for correct password

UserName = ""
If Trim(txtUserName.Text = "") Then
MsgBox "没有这个用户,请重新输入用户名!", vbOKOnly + vbExclamation, "警告"
txtUserName.SetFocus
Else
txtSQL = "select * from user_Info where user_ID = '" & txtUserName.Text & "'"
Set mrc = ExecuteSQL(txtSQL, MsgText)
If mrc.EOF = True Then
MsgBox "没有这个用户,请重新输入用户名!", vbOKOnly + vbExclamation, "警告"
txtUserName.SetFocus
Else
If Trim(mrc.Fields(1)) = Trim(txtPassword.Text) Then
OK =

Dim mrc As New ADODB.Recordset
Set mrc = ExecuteSQL(txtSQL, MsgText)

ExecuteSQL是一个函数,你看你的所有代码中有没有这个函数,然后把Set去掉看看!重要的还是找有没有ExecuteSQL这个函数!

提示你哪一行出错了?

我找到了ExecuteSQL函数的呀 去掉也也不行呀!!现在应该怎么弄呢?麻烦知道的帮帮忙哦 谢谢哦~