frmempquery.frm

数据库实现员工的管理

VERSION 5.00
Begin VB.Form frmEmpQuery 
   BackColor       =   &H0080C0FF&
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "查询员工信息"
   ClientHeight    =   2580
   ClientLeft      =   2760
   ClientTop       =   3750
   ClientWidth     =   5865
   Icon            =   "frmEmpQuery.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2580
   ScaleWidth      =   5865
   ShowInTaskbar   =   0   'False
   Begin VB.TextBox txtAge2 
      Height          =   375
      Left            =   3120
      TabIndex        =   13
      Top             =   1080
      Width           =   975
   End
   Begin VB.TextBox txtAddress 
      Height          =   375
      Left            =   1440
      TabIndex        =   11
      Top             =   2040
      Width           =   2655
   End
   Begin VB.ComboBox cmbDate 
      Height          =   300
      Left            =   1440
      Style           =   2  'Dropdown List
      TabIndex        =   10
      Top             =   1680
      Width           =   2655
   End
   Begin VB.TextBox txtAge1 
      Height          =   375
      Left            =   1440
      TabIndex        =   9
      Top             =   1080
      Width           =   975
   End
   Begin VB.TextBox txtName 
      Height          =   375
      Left            =   1440
      TabIndex        =   8
      Top             =   600
      Width           =   2655
   End
   Begin VB.TextBox txtCode 
      Height          =   375
      Left            =   1440
      TabIndex        =   7
      Top             =   120
      Width           =   2655
   End
   Begin VB.CommandButton CancelButton 
      Caption         =   "取消"
      Height          =   375
      Left            =   4440
      TabIndex        =   1
      Top             =   600
      Width           =   1215
   End
   Begin VB.CommandButton OKButton 
      Caption         =   "确定"
      Height          =   375
      Left            =   4440
      TabIndex        =   0
      Top             =   120
      Width           =   1215
   End
   Begin VB.Label Label6 
      BackColor       =   &H0080C0FF&
      Caption         =   "到"
      Height          =   255
      Left            =   2640
      TabIndex        =   12
      Top             =   1200
      Width           =   255
   End
   Begin VB.Label Label5 
      BackColor       =   &H0080C0FF&
      Caption         =   "地址信息包含"
      Height          =   255
      Left            =   240
      TabIndex        =   6
      Top             =   2160
      Width           =   1215
   End
   Begin VB.Label Label4 
      BackColor       =   &H0080C0FF&
      Caption         =   "加入日期晚于"
      Height          =   255
      Left            =   240
      TabIndex        =   5
      Top             =   1680
      Width           =   1215
   End
   Begin VB.Label Label3 
      BackColor       =   &H0080C0FF&
      Caption         =   "员工年龄段"
      Height          =   255
      Left            =   240
      TabIndex        =   4
      Top             =   1200
      Width           =   1095
   End
   Begin VB.Label Label2 
      BackColor       =   &H0080C0FF&
      Caption         =   "员工姓名包含"
      Height          =   255
      Left            =   240
      TabIndex        =   3
      Top             =   720
      Width           =   1095
   End
   Begin VB.Label Label1 
      BackColor       =   &H0080C0FF&
      Caption         =   "员工号码包含"
      Height          =   255
      Left            =   240
      TabIndex        =   2
      Top             =   240
      Width           =   1215
   End
End
Attribute VB_Name = "frmEmpQuery"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Option Explicit




Private Sub CancelButton_Click()
    Unload Me
End Sub

Private Sub Form_Load()
    Dim intindex As Integer
    cmbDate.Clear
    For intindex = 2000 To 2005
        cmbDate.AddItem intindex & "年"
    Next intindex
    txtAge1 = 18
    txtAge2 = 60
    cmbDate.ListIndex = 1
End Sub

Private Sub OKButton_Click()
    '因为frmQueryData是MDI子窗体，所以在显示该窗口之前，必须先关闭本窗体
    Unload Me
    frmQueryData.Show
End Sub