接触access1个多月,抽空就泡在论坛和QQ群里向各位大神学习,今天小试了下,做了个用户登录的功能,供像我一样的初学者学习交流。各位大神看到了,如有不足的地方,还请指正!
Option Compare Database
Private Sub 登录_Click()
Dim mm As String
If IsNull(textname) Then
MsgBox "选择登录用户名!"
Else
mm = DLookup("密码", "password", "id=" & [textname])
End If
If Me.textname <> "" Then
If IsNull(pw) Then
MsgBox "请输入密码!"
ElseIf Me.pw = mm Then
DoCmd.Close
DoCmd.OpenForm "main", , , stLinkCriteria
Else
MsgBox "密码不正确!"
End If
End If
End Sub
Private Sub 退出_Click()
DoCmd.Quit
End Sub