qqq 发表于:2014-03-06 12:08:51
如何自动更新,修改,,有点晕晕的。。
求老师指导一下
你的问题相当于如何把大象放进冰箱里,
首先,打开冰箱门
接着,把大象放进去
最后,关闭冰箱门
对比你这个问题就是
首先,判断旧密码是否匹配
接着,判断两个新密码是否一样
最后,把旧密码更新为新密码
嗯哪。。差不多吧。但是用户登录了。只能修改它自己的密码, 也就是自动判定修改ID的密码,代码改怎么写啊?? 前面的我会。。 到了如何把旧密码改为新密码的时候就开始纠结了
那就在判断旧密码是否匹配前先判断一下用户名是否为当前登陆用户
Private Sub Cancel_Click()
DoCmd.Close '关闭登陆窗口
End Sub
Private Sub PassWord0_Exit(Cancel As Integer)
If Me.PassWord0 = Me.PassWord Then '输入正确密码后可以更改用户姓名及密码
Me.UserName1.Enabled = True
Me.PassWord1.Enabled = True
Me.PassWord2.Enabled = True
Else
Me.UserName1.Enabled = False
Me.PassWord1.Enabled = False
Me.PassWord2.Enabled = False
End If
End Sub
Private Sub OK_Click()
On Error GoTo Err_OK_Click
If Me.PassWord1 <> Me.PassWord2 Then '核对两次输入的新密码是否一致
DoCmd.Beep
MsgBox "两次输入的新密码不一致!", vbOKOnly, "提示信息"
Me.PassWord1 = Null
Me.PassWord2 = Null
Me.PassWord1.SetFocus
ElseIf Me.PassWord0 = Me.PassWord And Me.UserName1 <> Me.UserName And Me.PassWord1 = Me.PassWord2 Then '核对新密码准确后更新密码
Me.PassWord = Me.PassWord1
Me.UserName = Me.UserName1
MsgBox "登录信息修改成功!点击'确定'将退出系统,请重新登录!", vbOKOnly, "提示信息"
DoCmd.Quit
ElseIf Me.PassWord0 = Me.PassWord And Me.PassWord1 = Me.PassWord2 Then '核对新密码准确后更新密码
Me.PassWord = Me.PassWord1
Me.UserName = Me.UserName1
MsgBox "登录密码修改成功!点击'确定'将退出系统,请重新登录!", vbOKOnly, "提示信息"
DoCmd.Quit
End If
Exit_OK_Click:
Exit Sub
Err_OK_Click:
MsgBox (err.Description)
Resume Exit_OK_Click
End Sub
感谢感谢
代码错误哎。。 运行不了- -
总记录:6篇 页次:1/1 9 1 :