各位老兄帮帮忙,小女子感谢了!在线等待.......
我在编写一个管理系统,其中有一登录程序,
程序如下:
Private Sub cmdlogin_Click()
uid = txtusername.Text
pwd = txtpassword.Text
if db.connectionstring<>"" then
msgbox"请先注销再登录!",,"登录"
unload me
exit sub
end if
db.ConnectionString = "provider=SQLOLEDB.1;" & "persist security info=false;" & "uid =" & uid & ";password=" & pwd & ";initial catalog=jxcdatabase;" & "data source=teacher;"
db.Open
With frmmain
!mnutrade.Enabled = True
!mnustatistics.Enabled = True
!mnubusinessman.Enabled = True
!mnucustomer.Enabled = True
!mnufactory.Enabled = True
!mnuproduct.Enabled = True
!mnuproductinput.Enabled = True
!mnuproductoutput.Enabled = True
!mnuretreat.Enabled = True
!mnustore.Enabled = True
!mnudatabase.Enabled = True
End With
Unload Me
End Sub
但是一按登录按钮时,出现以下提示:
实时错误“91”:
对象变量或WITH块变量未设置。
odbc数据源已设置且ADO已引用。