VERSION 5.00
Object = "{00028C01-0000-0000-0000-000000000046}#1.0#0"; "DBGRID32.OCX"
Begin VB.Form 刪除職工信息 
   Caption         =   "刪除職工信息"
   ClientHeight    =   8145
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   11460
   LinkTopic       =   "Form2"
   ScaleHeight     =   8145
   ScaleWidth      =   11460
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command3 
      Caption         =   "刪除"
      Height          =   615
      Left            =   4440
      TabIndex        =   6
      Top             =   5880
      Width           =   1455
   End
   Begin VB.CommandButton Command1 
      Caption         =   "查詢"
      Height          =   615
      Left            =   2280
      TabIndex        =   5
      Top             =   5880
      Width           =   1575
   End
   Begin VB.Frame Frame1 
      Caption         =   "請輸入員工編號與考勤當日"
      Height          =   1215
      Left            =   600
      TabIndex        =   2
      Top             =   4200
      Width           =   9255
      Begin VB.TextBox Text1 
         Height          =   390
         Left            =   3720
         TabIndex        =   3
         Top             =   480
         Width           =   1455
      End
      Begin VB.Label Label1 
         Caption         =   "員工編號 "
         Height          =   375
         Left            =   2400
         TabIndex        =   4
         Top             =   480
         Width           =   975
      End
   End
   Begin VB.CommandButton Command2 
      Caption         =   "退出"
      Height          =   615
      Left            =   6480
      TabIndex        =   1
      Top             =   5880
      Width           =   1455
   End
   Begin VB.Data Data1 
      Caption         =   "Data1"
      Connect         =   "Access 2000;"
      DatabaseName    =   "D:\人事管理系統\stuff.mdb"
      DefaultCursorType=   0  '缺省游標
      DefaultType     =   2  '使用 ODBC
      Exclusive       =   0   'False
      Height          =   285
      Left            =   6720
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   "職工信息表"
      Top             =   6120
      Width           =   1215
   End
   Begin MSDBGrid.DBGrid DBGrid1 
      Bindings        =   "刪除職工信息.frx":0000
      Height          =   3135
      Left            =   360
      OleObjectBlob   =   "刪除職工信息.frx":0014
      TabIndex        =   0
      Top             =   0
      Width           =   9855
   End
End
Attribute VB_Name = "刪除職工信息"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
  Data1.RecordSource = "select * from 職工信息表 where 員工編號='" + Trim(Text1.Text) + "'"
   Data1.Refresh

  If Data1.Recordset.RecordCount = 0 Then
MsgBox "紀錄不存在！"
End If
End Sub

Private Sub Command2_Click()
Me.Hide
'On Error Resume Next
End Sub

Private Sub Command3_Click()
Data1.Recordset.Delete
'On Error Resume Next
End Sub