?? frmlogin.frm
字號:
VERSION 5.00
Begin VB.Form frmLogin
BorderStyle = 3 'Fixed Dialog
Caption = "登錄"
ClientHeight = 1728
ClientLeft = 2832
ClientTop = 3480
ClientWidth = 3756
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 1019.187
ScaleMode = 0 'User
ScaleWidth = 3521.047
ShowInTaskbar = 0 'False
StartUpPosition = 2 'CenterScreen
Begin VB.CommandButton cmdMod
Caption = "修改"
Enabled = 0 'False
Height = 390
Left = 2520
TabIndex = 6
Top = 1080
Width = 1140
End
Begin VB.TextBox txtUserName
Height = 345
Left = 1290
TabIndex = 1
Text = "AA"
Top = 135
Width = 2325
End
Begin VB.CommandButton cmdOK
Caption = "確定"
Height = 390
Left = 120
TabIndex = 4
Top = 1080
Width = 1140
End
Begin VB.CommandButton cmdCancel
Caption = "取消"
Height = 390
Left = 1320
TabIndex = 5
Top = 1080
Width = 1140
End
Begin VB.TextBox txtPassword
Height = 345
IMEMode = 3 'DISABLE
Left = 1290
PasswordChar = "*"
TabIndex = 3
Top = 525
Width = 2325
End
Begin VB.Label lblLabels
Caption = "用戶名(&U):"
Height = 270
Index = 0
Left = 105
TabIndex = 0
Top = 150
Width = 1080
End
Begin VB.Label lblLabels
Caption = "密碼(&P):"
Height = 270
Index = 1
Left = 105
TabIndex = 2
Top = 540
Width = 1080
End
End
Attribute VB_Name = "frmLogin"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim PASS As String
Dim txt As String
Dim I As Integer
Dim DB As Database
Dim Modi As Boolean
Dim rec As Recordset
Public Password As String
Public LoginSucceeded As Boolean
Public User As String
Private Sub cmdCancel_Click()
'設置全局變量為 false,指示登錄失敗
LoginSucceeded = False
Me.Hide
Unload Me
End Sub
Private Sub cmdMod_Click()
txtPassword = ""
MsgBox "輸入密碼后按回車確認!", vbInformation + vbOKOnly
End Sub
Private Sub TXTPASSWORD_KeyPress(KeyAscii As Integer)
Dim S As String
If Modi Then
If KeyAscii = 13 Then
If I = 1 Then
If txtPassword.Text = PASS Then
S = "update user set password='" + Trim(PASS) + "' where user='" + Trim(txt) + "'"
DB.Execute S
Unload Me
'顯示主窗體
User = "" + Trim(txtUserName) + ""
Else
I = 0
End If
End If
If I = 0 Then
PASS = txtPassword
txtPassword = ""
End If
I = I + 1
End If
End If
End Sub
Private Sub cmdOK_Click()
'檢查密碼的正確性
Dim S As Boolean
On Error GoTo 1
S = True
Dim SQL As String
SQL = "select * from user where user='" + Trim(txtUserName) + "'"
Set rec = DB.OpenRecordset(SQL, dbOpenSnapshot)
rec.MoveFirst
If txtPassword = rec!Password Then
'此處放置代碼給調用子程序傳遞成功信息
'設置全局變量是最簡單的
LoginSucceeded = True
If MsgBox("修改密碼!", vbInformation + vbOKCancel) = vbOK Then
Modi = True
txt = "" + Trim(txtUserName) + ""
cmdMod.Enabled = True
txtPassword.SetFocus
Else
Unload Me
'顯示主窗體
User = "" + Trim(txtUserName) + ""
End If
Else
MsgBox "無效的密碼,再試一次!", , "登錄"
txtPassword.SetFocus
SendKeys "{Home}+{End}"
End If
S = False
If S Then
1: MsgBox "用戶名不正確", vbInformation + vbOKOnly
Exit Sub
End If
End Sub
Private Sub Form_Load()
Set dbStudent = OpenDatabase(App.Path + "\database\student.mdb", False, False)
Modi = False
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -