dialog.frm

来自「小区巡逻管理靠请系统。需要硬件支持才可以工作」· FRM 代码 · 共 213 行

VERSION 5.00
Begin VB.Form Dialog 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "修改密码"
   ClientHeight    =   3420
   ClientLeft      =   2760
   ClientTop       =   3750
   ClientWidth     =   6075
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   3420
   ScaleWidth      =   6075
   ShowInTaskbar   =   0   'False
   Begin VB.TextBox nextpass 
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   465
      IMEMode         =   3  'DISABLE
      Left            =   1425
      PasswordChar    =   "*"
      TabIndex        =   5
      Top             =   2250
      Width           =   2565
   End
   Begin VB.TextBox newpass 
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   465
      IMEMode         =   3  'DISABLE
      Left            =   1425
      PasswordChar    =   "*"
      TabIndex        =   4
      Top             =   1575
      Width           =   2565
   End
   Begin VB.TextBox oldpass 
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   465
      IMEMode         =   3  'DISABLE
      Left            =   1425
      PasswordChar    =   "*"
      TabIndex        =   3
      Top             =   900
      Width           =   2565
   End
   Begin VB.TextBox user 
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   465
      Left            =   1425
      TabIndex        =   2
      Top             =   225
      Width           =   2565
   End
   Begin VB.CommandButton CancelButton 
      Caption         =   "取消"
      Height          =   375
      Left            =   4425
      TabIndex        =   1
      Top             =   1650
      Width           =   1215
   End
   Begin VB.CommandButton OKButton 
      Caption         =   "确定"
      Height          =   375
      Left            =   4425
      TabIndex        =   0
      Top             =   975
      Width           =   1215
   End
   Begin VB.Label Label4 
      Caption         =   "确认输入："
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   315
      Left            =   225
      TabIndex        =   9
      Top             =   2325
      Width           =   1290
   End
   Begin VB.Label Label3 
      Caption         =   "新密码："
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   315
      Left            =   225
      TabIndex        =   8
      Top             =   1650
      Width           =   1140
   End
   Begin VB.Label Label2 
      Caption         =   "旧密码："
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   315
      Left            =   225
      TabIndex        =   7
      Top             =   975
      Width           =   1140
   End
   Begin VB.Label Label1 
      Caption         =   "用户名："
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   315
      Left            =   225
      TabIndex        =   6
      Top             =   300
      Width           =   1140
   End
End
Attribute VB_Name = "Dialog"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Option Explicit
Public db As Database
Public rs As DAO.Recordset
Private Sub CancelButton_Click()
Unload Dialog
End Sub

Private Sub Form_Load()
Set db = OpenDatabase(App.Path & "\data.mdb")
End Sub

Private Sub OKButton_Click()
Dim usert, oldpassword As String
Dim ch As Integer
Set rs = db.OpenRecordset("select * from 杂项 where 用户='" & user.Text & "'")
If oldpass.Text = rs.Fields("密码") Then
   If newpass.Text = nextpass.Text Then
      rs.Edit
      rs.Fields("密码") = newpass.Text
      rs.Update
      ch = MsgBox("您已成功的修改了密码", vbDefaultButton1 + vbInformation, "修改密码")
   Else
      ch = MsgBox("输入的密码不同，请重试", vbDefaultButton1 + vbExclamation, "修改密码")
      user.SetFocus
      SendKeys "{Home}+{End}"
      GoTo old
   End If
Else
   ch = MsgBox("输入的密码错误，请重试", vbDefaultButton1 + vbExclamation, "修改密码")
   oldpass.SetFocus
   SendKeys "{Home}+{End}"
   GoTo old
End If
Unload Me
old:
End Sub