xiugaiyonghu.frm

宾馆在正常的运营中需要对客房资源、顾客信息、结算信息进行管理

VERSION 5.00
Begin VB.Form xiugaiyonghu 
   Caption         =   "修改用户"
   ClientHeight    =   3195
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   4680
   Icon            =   "xiugaiyonghu.frx":0000
   LinkTopic       =   "Form1"
   ScaleHeight     =   3195
   ScaleWidth      =   4680
   StartUpPosition =   3  '窗口缺省
   Begin VB.Frame Frame1 
      Height          =   3135
      Left            =   0
      TabIndex        =   0
      Top             =   0
      Width           =   4695
      Begin VB.TextBox Text4 
         Height          =   375
         IMEMode         =   3  'DISABLE
         Left            =   1920
         TabIndex        =   7
         Top             =   1680
         Width           =   2415
      End
      Begin VB.TextBox Text3 
         Height          =   375
         Left            =   1920
         TabIndex        =   6
         Top             =   960
         Width           =   2415
      End
      Begin VB.CommandButton Command2 
         Caption         =   "取消"
         Height          =   495
         Left            =   3000
         TabIndex        =   4
         Top             =   2280
         Width           =   1215
      End
      Begin VB.CommandButton Command1 
         Caption         =   "确认"
         Height          =   495
         Left            =   840
         TabIndex        =   3
         Top             =   2280
         Width           =   1215
      End
      Begin VB.TextBox Text1 
         Height          =   390
         Left            =   1920
         TabIndex        =   2
         Top             =   240
         Width           =   2415
      End
      Begin VB.Label Label4 
         Caption         =   "现在使用的密码:"
         Height          =   255
         Left            =   360
         TabIndex        =   8
         Top             =   960
         Width           =   1455
      End
      Begin VB.Label Label3 
         Caption         =   "帐号:"
         Height          =   255
         Left            =   840
         TabIndex        =   5
         Top             =   240
         Width           =   495
      End
      Begin VB.Label Label1 
         Caption         =   "请输入新密码:"
         Height          =   255
         Left            =   360
         TabIndex        =   1
         Top             =   1680
         Width           =   1215
      End
   End
End
Attribute VB_Name = "xiugaiyonghu"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub Command1_Click()
Dim db As Database
Dim rs As Recordset
Dim m As String
Dim a As String
On Error Resume Next
Set db = OpenDatabase(App.Path & "\登陆信息表")
Set rs = db.OpenRecordset("登陆信息表")
If Text3.Text <> "" Then
Set rs = db.OpenRecordset("select 帐号,密码 from 登陆信息表 where 帐号='" & Text1.Text & "'and 密码='" & Text3.Text & "'")
If rs.EOF = True And rs.BOF = True Then
m = MsgBox("你的用户信息错误,重新输入!", vbOKCancel)
Text1.Text = ""
Text1.SetFocus
Text3.Text = ""
Text3.SetFocus
Else
a = "update 登陆信息表 set 密码='" & Text4.Text & "'where 帐号='" & Text1.Text & "'"
db.Execute a
MsgBox ("修改成功!")
xiugaiyonghu.Hide
mima.Show
mima.Text2.Text = ""
End If
rs.Close
End If
End Sub

Private Sub Command2_Click()
xiugaiyonghu.Hide
jiudianneibuziliaocaidan.Show
End Sub