Option Explicit
Dim adoPassRS As ADODB.RecordsetPrivate Sub cmdCancel_Click()
End
End SubPrivate Sub cmdOK_Click()
Dim FindUser As String
FindUser = txtUserName.Text
Set adoPassRS = New ADODB.Recordset
adoPassRS.Open "Select * from UserList where user = '" & FindUser & "'", DB, adOpenStatic, adLockOptimistic
If Not adoPassRS.BOF Then
adoPassRS.MoveFirst
End If
If adoPassRS.RecordCount <> 0 Then
If adoPassRS("Password") = txtPassword.Text Then
frmLogin.Hide
frmMain.Show
ElseIf adoPassRS("Password") <> txtPassword.Text Then
txtPassword.Text = ""
txtPassword.SetFocus
End If
Else
MsgBox "User does not exits!"
txtUserName.Text = ""
txtUserName.SetFocus
End If
End Sub***********************************************************
Option Explicit
Global Const DEFSOURCE = "PROVIDER=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source="
Global Const DBName = "\Contract.MDB;Jet OLEDB:Database Password=matrix-se;"Public DB As ADODB.Connection***********************************************************运行时总说adoPassRS没有定义,怎么回事啊?帮看看问题出在哪儿?谢啦
Dim adoPassRS As ADODB.RecordsetPrivate Sub cmdCancel_Click()
End
End SubPrivate Sub cmdOK_Click()
Dim FindUser As String
FindUser = txtUserName.Text
Set adoPassRS = New ADODB.Recordset
adoPassRS.Open "Select * from UserList where user = '" & FindUser & "'", DB, adOpenStatic, adLockOptimistic
If Not adoPassRS.BOF Then
adoPassRS.MoveFirst
End If
If adoPassRS.RecordCount <> 0 Then
If adoPassRS("Password") = txtPassword.Text Then
frmLogin.Hide
frmMain.Show
ElseIf adoPassRS("Password") <> txtPassword.Text Then
txtPassword.Text = ""
txtPassword.SetFocus
End If
Else
MsgBox "User does not exits!"
txtUserName.Text = ""
txtUserName.SetFocus
End If
End Sub***********************************************************
Option Explicit
Global Const DEFSOURCE = "PROVIDER=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source="
Global Const DBName = "\Contract.MDB;Jet OLEDB:Database Password=matrix-se;"Public DB As ADODB.Connection***********************************************************运行时总说adoPassRS没有定义,怎么回事啊?帮看看问题出在哪儿?谢啦
解决方案 »
- vb程序中路径设置为什么不能支持中文路径
- 有什么好办法解决通讯口的多用户操作?
- 怎么调用AUTOCAD文件!
- 请教各位高手:如何将文本框外观作成与按钮的3D外观一样?(在线等待)
- ttttt
- 请各位大大看一下还有没有能简化、优化的地方
- 关于VB+ACCESS数据库编程,没事也来看看,在线等待!!!!!!!!
- 請問,怎樣才能將所選的文件打開?
- 我用vb写excel sheet在直接用excel看不到结果,而在vb里面却可以,为什么?。。。高手帮忙呀
- 请教VB数据库的问题
- 在VB里怎么调用ishelllink接口啊?有经验朋友指教一下啊!高分相送!!
- DataGrid能否加上不是数据表中字段的一列用于接收输入?
Dim adoPassRS As new ADODB.Recordset
set adopassrs =new adodb.recordset
或者是
引用,“工程”--->“引用”-->"microsoft activex data objects 2.1"
或者是
引用,“工程”--->“引用”-->"microsoft activex data objects 2.5"
或者是
引用,“工程”--->“引用”-->"microsoft activex data objects 2.6"
或者是
引用,“工程”--->“引用”-->"microsoft activex data objects 2.7"
或者是
引用,“工程”--->“引用”-->"microsoft activex data objects 2.8"最好是:“工程”--->“引用”-->"microsoft activex data objects 2.7"
set adopassrs =new adodb.recordset
//
其实很简单检测你有没有定义,只要在VB里输入到AS后面时候.看看是否已经有了adodb.recordset
如果没有要引用不是定义,是引用,“工程”--->“引用”-->"microsoft activex data objects 2.x"
'你定义的连接对象怎么没有赋值?