VERSION 5.00
Object = "{00028C01-0000-0000-0000-000000000046}#1.0#0"; "DBGRID32.OCX"
Begin VB.Form 刪除考勤信息 
   Caption         =   "刪除考勤信息"
   ClientHeight    =   7065
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   11775
   LinkTopic       =   "Form1"
   ScaleHeight     =   7065
   ScaleWidth      =   11775
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command2 
      Caption         =   "退出"
      Height          =   735
      Left            =   6360
      TabIndex        =   8
      Top             =   6000
      Width           =   1455
   End
   Begin MSDBGrid.DBGrid DBGrid1 
      Bindings        =   "刪除考勤信息.frx":0000
      Height          =   1935
      Left            =   360
      OleObjectBlob   =   "刪除考勤信息.frx":0014
      TabIndex        =   7
      Top             =   480
      Width           =   9375
   End
   Begin VB.Data Data1 
      Caption         =   "Data1"
      Connect         =   "Access 2000;"
      DatabaseName    =   "D:\人事管理系統\stuff.mdb"
      DefaultCursorType=   0  '缺省游標
      DefaultType     =   2  '使用 ODBC
      Exclusive       =   0   'False
      Height          =   375
      Left            =   1080
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   "員工考勤表"
      Top             =   0
      Width           =   2775
   End
   Begin VB.Frame Frame1 
      Caption         =   "請輸入員工編號與考勤當日"
      Height          =   2415
      Left            =   360
      TabIndex        =   2
      Top             =   3120
      Width           =   9255
      Begin VB.TextBox Text1 
         Height          =   390
         Left            =   1560
         TabIndex        =   6
         Top             =   600
         Width           =   1455
      End
      Begin VB.TextBox Text2 
         Height          =   495
         Left            =   4560
         TabIndex        =   5
         Top             =   480
         Width           =   1575
      End
      Begin VB.Label Label3 
         Caption         =   "考勤當日"
         Height          =   375
         Left            =   3360
         TabIndex        =   4
         Top             =   600
         Width           =   975
      End
      Begin VB.Label Label1 
         Caption         =   "員工編號 "
         Height          =   375
         Left            =   480
         TabIndex        =   3
         Top             =   600
         Width           =   975
      End
   End
   Begin VB.CommandButton Command1 
      Caption         =   "查詢"
      Height          =   615
      Left            =   2040
      TabIndex        =   1
      Top             =   6120
      Width           =   1575
   End
   Begin VB.CommandButton Command3 
      Caption         =   "刪除"
      Height          =   615
      Left            =   4320
      TabIndex        =   0
      Top             =   6120
      Width           =   1455
   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