Private Sub cmdOK_Click()
Dim dbLogin As Database
Dim rsLogin As Recordset
Dim rsLogpass As Recordset
Dim SQLName As String
Dim SQLpass As String
SQLName = "select * from login where log_name='txtusername.text'"
Set dbLogin = OpenDatabase("C:\Program Files\Microsoft Visual Studio\VB98\销售管理\logindb.mdb", False)
Set rsLogin = dbLogin.OpenRecordset(SQLName)
If frmLogin.txtPassword.Text <> rsLogin.Fields(1).Value Then
MsgBox "password error!"
Else
LoginSucceeded = True
MsgBox "登录成功"
Me.Hide
请指教
Dim dbLogin As Database
Dim rsLogin As Recordset
Dim rsLogpass As Recordset
Dim SQLName As String
Dim SQLpass As String
SQLName = "select * from login where log_name='txtusername.text'"
Set dbLogin = OpenDatabase("C:\Program Files\Microsoft Visual Studio\VB98\销售管理\logindb.mdb", False)
Set rsLogin = dbLogin.OpenRecordset(SQLName)
If frmLogin.txtPassword.Text <> rsLogin.Fields(1).Value Then
MsgBox "password error!"
Else
LoginSucceeded = True
MsgBox "登录成功"
Me.Hide
请指教
有问题!!!应为
SQLName = "select * from login where log_name='"& txtusername.text &"' "
----------------
类型错误!修改数据库字段类型或加入inttostr(rsLogin.firelds(1).value)
-----------------
可能出现错误的原因:
1、象前面misterzhao所讲的那样, rsLogin对象为空
2、另外可能是数据类型错误。你的密码字段是不是login 表的第二个字段,因为表的索引值是从0开始的。