frmaddress.frm

就是开发一个简易的银行卡管理系统,对持卡人信息和基本操作信息进行管理。 简易银行卡管理系统的主要功能： ●新开设一个帐户 ●能够进行存款操作 ●能够进行取款操作 ●挂失帐户

VERSION 5.00
Begin VB.Form frmFirst 
   BackColor       =   &H00C0FFC0&
   BorderStyle     =   1  'Fixed Single
   Caption         =   "简易ATM系统   "
   ClientHeight    =   4455
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   6720
   Icon            =   "frmAddress.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   4455
   ScaleWidth      =   6720
   StartUpPosition =   1  '所有者中心
   WhatsThisHelp   =   -1  'True
   Begin VB.CommandButton cmdNew 
      Caption         =   "开  户"
      Height          =   495
      Left            =   2400
      TabIndex        =   6
      Top             =   3480
      Width           =   1335
   End
   Begin VB.TextBox txtPass 
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   555
      IMEMode         =   3  'DISABLE
      Left            =   2640
      PasswordChar    =   "*"
      TabIndex        =   5
      Top             =   2400
      Width           =   3015
   End
   Begin VB.TextBox txtName 
      Height          =   615
      Left            =   2640
      TabIndex        =   4
      Top             =   1200
      Width           =   3015
   End
   Begin VB.CommandButton cmdExit 
      Appearance      =   0  'Flat
      Caption         =   "退  出"
      Height          =   495
      Left            =   4320
      TabIndex        =   3
      Top             =   3480
      Width           =   1335
   End
   Begin VB.CommandButton cmdSearch 
      BackColor       =   &H00FFFFFF&
      Caption         =   "登  录"
      Height          =   495
      Left            =   480
      TabIndex        =   2
      Top             =   3480
      Width           =   1335
   End
   Begin VB.Label Label3 
      Appearance      =   0  'Flat
      BackColor       =   &H00C0FFC0&
      Caption         =   "欢迎使用银行卡管理系统"
      BeginProperty DataFormat 
         Type            =   2
         Format          =   ""
         HaveTrueFalseNull=   0
         FirstDayOfWeek  =   0
         FirstWeekOfYear =   0
         LCID            =   2052
         SubFormatType   =   9
      EndProperty
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   18
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H80000008&
      Height          =   375
      Left            =   1080
      TabIndex        =   7
      Top             =   360
      Width           =   4455
   End
   Begin VB.Line Line8 
      X1              =   480
      X2              =   2160
      Y1              =   2880
      Y2              =   2880
   End
   Begin VB.Line Line7 
      X1              =   480
      X2              =   2160
      Y1              =   2400
      Y2              =   2400
   End
   Begin VB.Line Line6 
      X1              =   2160
      X2              =   2160
      Y1              =   2400
      Y2              =   2880
   End
   Begin VB.Line Line5 
      X1              =   480
      X2              =   480
      Y1              =   2400
      Y2              =   2880
   End
   Begin VB.Line Line4 
      X1              =   2160
      X2              =   2160
      Y1              =   1200
      Y2              =   1680
   End
   Begin VB.Line Line3 
      X1              =   480
      X2              =   480
      Y1              =   1200
      Y2              =   1680
   End
   Begin VB.Line Line2 
      X1              =   480
      X2              =   2160
      Y1              =   1680
      Y2              =   1680
   End
   Begin VB.Line Line1 
      X1              =   480
      X2              =   2160
      Y1              =   1200
      Y2              =   1200
   End
   Begin VB.Label Label2 
      Alignment       =   1  'Right Justify
      AutoSize        =   -1  'True
      BackColor       =   &H00C0FFC0&
      Caption         =   "请输入密码:"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   330
      Left            =   480
      TabIndex        =   1
      Top             =   2520
      Width           =   1515
   End
   Begin VB.Label Label1 
      Alignment       =   1  'Right Justify
      BackColor       =   &H00C0FFC0&
      Caption         =   "请输入用户名:"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   375
      Left            =   600
      TabIndex        =   0
      Top             =   1320
      Width           =   1455
   End
   Begin VB.Menu 帮助 
      Caption         =   "帮助(Help)"
      Visible         =   0   'False
      WindowList      =   -1  'True
   End
   Begin VB.Menu 注意事项 
      Caption         =   "注意事项(Warning)"
      Visible         =   0   'False
   End
End
Attribute VB_Name = "frmFirst"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim db As Database '设置变量
Dim rs As Recordset
Private Sub cmdNew_Click() '选择开户
frmNew.Show
Hide
End Sub
Private Sub cmdSearch_Click() '登陆验证
Dim LOGIN As Boolean
Set rs = db.OpenRecordset("SELECT * FROM Person") '查找用户
NameQuery = txtName.Text
PassQuery = txtPass.Text
rs.MoveFirst
Do Until rs.EOF
If rs.Fields("用户名") Like LCase(NameQuery) And rs.Fields("密码") Like LCase(PassQuery) Then '用户名和密码同时符合
LOGIN = True
Hide
frmInfor.Show
Exit Sub

ElseIf rs.Fields("用户名") Like LCase(" " & NameQuery) And rs.Fields("密码") Like LCase(PassQuery) Then
MsgBox "对不起,这个用户已被挂失！", vbOKOnly + vbExclamation, "错误"
txtName.Text = ""
txtPass.Text = ""
Exit Sub

Else
rs.MoveNext
End If
Loop
If LOGIN = False Then '登陆失败
MsgBox "对不起，你的用户名不存在或者密码错误！请核对后重新输入！", vbOKOnly + vbExclamation, "错误"
End If

End Sub
Private Sub cmdExit_Click() '退出系统
Dim response
response = MsgBox("是否退出?", vbOKCancel + vbQuestion, "退出")
If response = 1 Then
End
End If
End Sub
Private Sub Form_Load() '窗体加载
Set db = OpenDatabase(App.Path + "/cw.mdb")
Set rs = db.OpenRecordset("Person")
Show
Me.Font.Size = 12

End Sub