With DataEnvironment1.rsCommand1
.Open "select * from name where 用户名='" & Text4.Text & "' and 密码='" & Text1.Text & "'"
If .EOF Then
MsgBox "用户名或密码不正确"
Text4.Text = ""
Text1.Text = ""
Text4.SetFocus
.Close
Else
If Text2.Text = Text3.Text Then
DataEnvironment1.rsCommand1![密码] = Text2.Text
DataEnvironment1.rsCommand1.Update
MsgBox "密码更新完毕"
Unload Dialog
Else
MsgBox "新密码错误,请重新更新新密码"
Text3.Text = ""
End If
End If
.Close
End With出现 错误对话框“运行时错误,’3705‘,对象打开时,不允许操作
.Open "select * from name where 用户名='" & Text4.Text & "' and 密码='" & Text1.Text & "'"
If .EOF Then
MsgBox "用户名或密码不正确"
Text4.Text = ""
Text1.Text = ""
Text4.SetFocus
.Close
Else
If Text2.Text = Text3.Text Then
DataEnvironment1.rsCommand1![密码] = Text2.Text
DataEnvironment1.rsCommand1.Update
MsgBox "密码更新完毕"
Unload Dialog
Else
MsgBox "新密码错误,请重新更新新密码"
Text3.Text = ""
End If
End If
.Close
End With出现 错误对话框“运行时错误,’3705‘,对象打开时,不允许操作
解决方案 »
- 怎样来定义这样一个数据源?
- VB出现这个问题,怎么办?
- VB中的数据添加问题
- 怎么得到表的指定记录?
- 好久不用VB了,现在VB的版本是多少啊!还是VB6.0吗?
- 急:装VB时,提示“没有发现ACME安装程序”!!!
- 如何找到一个日历控件?哪位有好一点的日历控件发一个给我,谢谢!([email protected])
- 错误描述:无法为更新定位行。一些值可能已在最后一次读取后已更改。
- 不安装VB.NET能否运行Microsoft Visual Studio OLE/COM?
- 请问有人用VB开发过与PLC进行串行通讯的程序吗?
- 如何在NT内核的操作系统上隐藏文件夹.顶者有分.
- 请问VB中有办法让程序中的文本框的文本显示IE的地址栏上吗?
With DataEnvironment1.rsCommand1
if .State=adStateOpen Then .Close '如果记录集对象一样打开,则将它关闭
.Open "select * from name where 用户名='" & Text4.Text & "' and 密码='" & Text1.Text & "'"
......
If .State = adStateOpen Then .Close
.Open "select * from name where 用户名='" & Text4.Text & "' and 密码='" & Text1.Text & "'"
If .EOF Then
MsgBox "用户名或密码不正确"
Text4.Text = ""
Text1.Text = ""
Text4.SetFocus
Else
If Text2.Text = Text3.Text Then
DataEnvironment1.rsCommand1![密码] = Text2.Text
DataEnvironment1.rsCommand1.Update
MsgBox "密码更新完毕"
Unload Dialog
Else
MsgBox "新密码错误,请重新更新新密码"
Text3.Text = ""
End If
End If
.Close
End With
还是不好用