VB新手,未找到方法或数据成员。急!解决后可再加分

来源:百度知道 编辑:UC知道 时间:2024/04/28 04:35:33
我制作的是一个登陆界面,要求输入用户名和密码之后在数据库里查找,如果找到该用户并且密码正确的话就进入系统,否则重新输入。
代码如下:
Option Explicit
Dim txtSQL As String
Dim mrc As ADODB.Recordset
Dim MsgText As String
Dim miCount As Integer
Public LoginSucceeded As Boolean
Private Sub Form_Load() '加载窗体时代码
Dim i As Integer
i = 0
txtSQL = "select * from 用户信息表"
Set mrc = ExecuteSQL(txtSQL, MsgText)
With txtUserName
Do While Not mrc.EOF
i = i + 1
.AddItem Trim(mrc!用户名称)
mrc.MoveNext
Loop
.ListIndex = i - 1 ‘编译时在这里提示未找到方法或数据成员!
End With
mrc.Close
LoginSucceeded = False
miCount = 0
End Sub

Private Sub cmdCancel_Click()
'设置全局变量为 false
'不提示失败的登录
LoginSucceeded = False
Me.Hide
End Sub

Private Sub cmdOK_Click()
txtSQL = "select * from 用户信息表 where

txtUserName应该是Combo控件

Private Sub Form_Load() '加载窗体时代码
LoginSucceeded = False
miCount = 0
End Sub

如果不是txtUserName控件应该不存在ListIndex方法,那程序就没有问题。