运行工程时,找不到工程或库?
一客户管理系统,在加载运行时,出现编译错误"找不到工程或库存",请教各位究竟是哪儿出了问题?
注:数据和工程文件在同一目录下,
strConnection = "Provider=Microsoft.jet.oledb.4.0;Data Source=" & App.Path & "\"
strConnection = strConnection & "Client.mdb"
在下面的这样用户登录处出问题,其他位置也有:
Private Sub cmdOK_Click()
Dim sql As String
Dim rs As ADODB.Recordset
If Trim(UserName.Text = "") Then
MsgBox "没有输入用户名称,请重新输入!", vbOKOnly + vbExclamation, "警告"
UserName.SetFocus
Else '查询用户
sql = "select * from UserInfo where UserID='" & UserName.Text & "'"
Set rs = getRS(sql)
If iflag = 1 Then
If rs.EOF = True Then
MsgBox "没有这个用户,请重新输入!", vbOKOnly + vbExclamation, "警告"
UserName.SetFocus
Else
If Trim(rs.Fields(1)) = Trim(PassWord.Text) Then
rs.Close
Me.Hide
strUserName = Trim(UserName.Text) '保存用户名称
frmMain.Show
Unload Me
Else
MsgBox "密码不正确,请重新输入!", vbOKOnly + vbExclamation, "警告"
PassWord.SetFocus
PassWord.Text = ""
End If
End If
Else
Unload Me
End If
End If
pwdCount = pwdCount + 1 '判断输入次数
If pwdCount = 3 Then
Unload Me
Exit Sub
End If
End Sub
------------------------------------------------------
-------------------------------------------------------
在If Trim(UserName.Text = "") Then----处的Trim出错,"找不到工程或库存"
不知为何,请高手给予详解!谢谢