📄 pass_ch_form.frm
字号:
VERSION 5.00
Begin VB.Form PASSWORD_CHG_FORM
Caption = "PASSWORD CHANGE"
ClientHeight = 4095
ClientLeft = 60
ClientTop = 450
ClientWidth = 5910
LinkTopic = "Form1"
ScaleHeight = 4095
ScaleWidth = 5910
StartUpPosition = 3 'Windows Default
Begin VB.Frame Frame1
BackColor = &H00FFFFFF&
ForeColor = &H00FFFFFF&
Height = 4815
Left = 0
TabIndex = 0
Top = 0
Width = 6135
Begin VB.TextBox t3
Appearance = 0 'Flat
Height = 375
IMEMode = 3 'DISABLE
Left = 3240
PasswordChar = "*"
TabIndex = 5
ToolTipText = "Retype New Password Here"
Top = 2640
Width = 1695
End
Begin VB.CommandButton passcmd2
BackColor = &H00FFC0FF&
Caption = "Cancel"
BeginProperty Font
Name = "Arial Black"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 3120
Style = 1 'Graphical
TabIndex = 4
ToolTipText = "Click to Quit"
Top = 3480
Width = 1095
End
Begin VB.CommandButton passcmd1
BackColor = &H00FFC0FF&
Caption = "Set"
BeginProperty Font
Name = "Arial Black"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 840
Style = 1 'Graphical
TabIndex = 3
ToolTipText = "Click To Set Password"
Top = 3480
Width = 1095
End
Begin VB.TextBox t2
Appearance = 0 'Flat
Height = 375
IMEMode = 3 'DISABLE
Left = 3240
PasswordChar = "*"
TabIndex = 2
ToolTipText = "Enter New Password Here"
Top = 2040
Width = 1695
End
Begin VB.TextBox t1
Appearance = 0 'Flat
Height = 375
IMEMode = 3 'DISABLE
Left = 3240
PasswordChar = "*"
TabIndex = 1
ToolTipText = "Enter Old Password Here"
Top = 1320
Width = 1695
End
Begin VB.Label passlbl2
BackStyle = 0 'Transparent
Caption = "Password Change"
BeginProperty Font
Name = "Arial"
Size = 18
Charset = 0
Weight = 700
Underline = 0 'False
Italic = -1 'True
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 855
Left = 1800
TabIndex = 9
Top = 360
Width = 2055
End
Begin VB.Label passlbl1
BackColor = &H00FFFFFF&
Caption = "Enter Old Password:-"
BeginProperty Font
Name = "Fixedsys"
Size = 9
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF8080&
Height = 255
Left = 240
TabIndex = 8
Top = 1440
Width = 2895
End
Begin VB.Label Label1
BackColor = &H00FFFFFF&
Caption = "Enter New Password:-"
BeginProperty Font
Name = "Fixedsys"
Size = 9
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00C00000&
Height = 255
Left = 240
TabIndex = 7
Top = 2160
Width = 2895
End
Begin VB.Label Label2
BackColor = &H00FFFFFF&
Caption = "Retype New Password:-"
BeginProperty Font
Name = "Fixedsys"
Size = 9
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00C00000&
Height = 255
Left = 240
TabIndex = 6
Top = 2760
Width = 2895
End
Begin VB.Line Line1
BorderColor = &H0080C0FF&
BorderWidth = 2
X1 = 0
X2 = 5880
Y1 = 1800
Y2 = 1800
End
Begin VB.Line Line2
BorderColor = &H0080C0FF&
BorderWidth = 2
X1 = 0
X2 = 5880
Y1 = 3360
Y2 = 3360
End
Begin VB.Image Image1
Height = 1065
Left = 360
Picture = "PASS_CH_FORM.frx":0000
Top = 240
Width = 945
End
End
Begin VB.Data Data1
Caption = "Data1"
Connect = "Access"
DatabaseName = "C:\database\Nursery management data base.mdb"
DefaultCursorType= 0 'DefaultCursor
DefaultType = 2 'UseODBC
Exclusive = 0 'False
Height = 345
Left = 1200
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "password"
Top = 4200
Visible = 0 'False
Width = 3060
End
End
Attribute VB_Name = "PASSWORD_CHG_FORM"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim rs As New adodb.Recordset
Dim LOGIN As Integer
Dim db As New adodb.Connection
Dim npass, rpass, dpass, SQL1 As String
Private Sub Form_Load()
db.Open "Provider=OraOLEDB.Oracle.1;Password=TIGER;Persist Security Info=True;User ID=SCOTT"
SQL1 = "select * from ARS_TEACHENTRY WHERE TID= " & LOGIN_FORM.LOGINID & ""
Set rs = db.Execute(SQL1)
End Sub
Private Sub passcmd1_Click()
dpass = rs.Fields(1)
If t1.Text = vbNullString Or t2.Text = "" Or t3.Text = "" Then
MsgBox "Please Enter All Fields", vbCritical, "Password change"
t1.Text = ""
t2.Text = ""
t3.Text = ""
Else
If t2.Text <> t3.Text Then
MsgBox "New & Retype Password Does Not Match", vbQuestion, "Password Change"
t2.Text = ""
t3.Text = ""
Else
rs.Update 1, t2.Text
MsgBox "New Password Sucessfully Set"
Unload Me
End If
End If
End Sub
Private Sub passcmd2_Click()
Unload Me
End Sub
Private Sub t2_Click()
dpass = rs.Fields(1)
'dpass = Data1.Recordset("password")
If t1.Text <> dpass Then
MsgBox "Invalid Old Password", vbQuestion, "Password Change"
t1.Text = vbNullString
t2.Text = vbNullString
t3.Text = vbNullString
End If
End Sub
Private Sub t3_Click()
'dpass = Data1.Recordset("password")
dpass = rs.Fields(1)
If t1.Text <> dpass Then
t1.Text = ""
t2.Text = ""
t3.Text = ""
MsgBox "Invalid Old Password", vbQuestion, "Password Change"
End If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -