PC World Komputer 1996 February/PCWK0296.iso/po7_win/object10/empmix.frm

Text File | 1994-11-14 | 9KB | 322 lines

VERSION 2.00
Begin Form frmMix
   BorderStyle     =   3  'Fixed Double
   Caption         =   "Employee (MixedFunction) Form"
   ClientHeight    =   3945
   ClientLeft      =   1890
   ClientTop       =   2700
   ClientWidth     =   6075
   Height          =   4635
   Left            =   1830
   LinkTopic       =   "Form1"
   ScaleHeight     =   3945
   ScaleWidth      =   6075
   Top             =   2070
   Width           =   6195
   Begin CommandButton cmdLast
      Caption         =   "Last"
      Height          =   495
      Left            =   4680
      TabIndex        =   12
      Top             =   3360
      Width           =   1215
   End
   Begin CommandButton cmdPrevious
      Caption         =   "Previous"
      Height          =   495
      Left            =   1680
      TabIndex        =   10
      Top             =   3360
      Width           =   1215
   End
   Begin CommandButton cmdNext
      Caption         =   "Next"
      Height          =   495
      Left            =   3360
      TabIndex        =   11
      Top             =   3360
      Width           =   1215
   End
   Begin CommandButton cmdFirst
      Caption         =   "First"
      Height          =   495
      Left            =   360
      TabIndex        =   9
      Top             =   3360
      Width           =   1215
   End
   Begin TextBox txtComm
      DataField       =   "comm"
      DataSource      =   "EmpData"
      Height          =   285
      Left            =   2640
      TabIndex        =   6
      Top             =   2280
      Width           =   1215
   End
   Begin TextBox txtDeptno
      DataField       =   "deptno"
      DataSource      =   "EmpData"
      Height          =   285
      Left            =   2640
      TabIndex        =   7
      Top             =   2640
      Width           =   1215
   End
   Begin TextBox txtSal
      DataField       =   "sal"
      DataSource      =   "EmpData"
      Height          =   285
      Left            =   2640
      TabIndex        =   5
      Top             =   1920
      Width           =   1215
   End
   Begin TextBox txtHireDate
      DataField       =   "hiredate"
      DataSource      =   "EmpData"
      Height          =   285
      Left            =   2640
      TabIndex        =   4
      Top             =   1560
      Width           =   1215
   End
   Begin TextBox txtMgr
      DataField       =   "mgr"
      DataSource      =   "EmpData"
      Height          =   285
      Left            =   2640
      TabIndex        =   3
      Top             =   1200
      Width           =   1215
   End
   Begin TextBox txtJob
      DataField       =   "job"
      DataSource      =   "EmpData"
      Height          =   285
      Left            =   2640
      TabIndex        =   2
      Top             =   840
      Width           =   2895
   End
   Begin TextBox txtEname
      DataField       =   "ename"
      DataSource      =   "EmpData"
      Height          =   285
      Left            =   2640
      TabIndex        =   1
      Top             =   480
      Width           =   2895
   End
   Begin TextBox txtEmpno
      DataField       =   "empno"
      DataSource      =   "EmpData"
      Height          =   285
      Left            =   2640
      TabIndex        =   0
      Top             =   120
      Width           =   1215
   End
   Begin OraData EmpData
      AllowMoveLast   =   -1  'True
      AutoBinding     =   -1  'True
      Caption         =   "         Previous Employee -- Next Employee"
      Connect         =   ""
      DatabaseName    =   ""
      Height          =   270
      HiddenName      =   "EmpData"
      Left            =   360
      Options         =   2162688
      ReadOnly        =   0   'False
      RecordSource    =   ""
      TabIndex        =   8
      Top             =   3000
      TrailingBlanks  =   0   'False
      Width           =   5535
   End
   Begin Label Label8
      Alignment       =   1  'Right Justify
      AutoSize        =   -1  'True
      Caption         =   "Department Number:"
      FontBold        =   -1  'True
      FontItalic      =   0   'False
      FontName        =   "MS Sans Serif"
      FontSize        =   9.75
      FontStrikethru  =   0   'False
      FontUnderline   =   0   'False
      Height          =   255
      Left            =   360
      TabIndex        =   20
      Top             =   2640
      Width           =   2175
   End
   Begin Label Label7
      Alignment       =   1  'Right Justify
      AutoSize        =   -1  'True
      Caption         =   "Commission:"
      FontBold        =   -1  'True
      FontItalic      =   0   'False
      FontName        =   "MS Sans Serif"
      FontSize        =   9.75
      FontStrikethru  =   0   'False
      FontUnderline   =   0   'False
      Height          =   255
      Left            =   1200
      TabIndex        =   19
      Top             =   2280
      Width           =   1335
   End
   Begin Label Label6
      Alignment       =   1  'Right Justify
      AutoSize        =   -1  'True
      Caption         =   "Salary:"
      FontBold        =   -1  'True
      FontItalic      =   0   'False
      FontName        =   "MS Sans Serif"
      FontSize        =   9.75
      FontStrikethru  =   0   'False
      FontUnderline   =   0   'False
      Height          =   255
      Left            =   1680
      TabIndex        =   18
      Top             =   1920
      Width           =   855
   End
   Begin Label Label5
      Alignment       =   1  'Right Justify
      AutoSize        =   -1  'True
      Caption         =   "Hire Date:"
      FontBold        =   -1  'True
      FontItalic      =   0   'False
      FontName        =   "MS Sans Serif"
      FontSize        =   9.75
      FontStrikethru  =   0   'False
      FontUnderline   =   0   'False
      Height          =   255
      Left            =   1440
      TabIndex        =   17
      Top             =   1560
      Width           =   1095
   End
   Begin Label Label4
      Alignment       =   1  'Right Justify
      AutoSize        =   -1  'True
      Caption         =   "Manager:"
      FontBold        =   -1  'True
      FontItalic      =   0   'False
      FontName        =   "MS Sans Serif"
      FontSize        =   9.75
      FontStrikethru  =   0   'False
      FontUnderline   =   0   'False
      Height          =   240
      Left            =   1560
      TabIndex        =   16
      Top             =   1200
      Width           =   990
   End
   Begin Label Label3
      Alignment       =   1  'Right Justify
      AutoSize        =   -1  'True
      Caption         =   "Job:"
      FontBold        =   -1  'True
      FontItalic      =   0   'False
      FontName        =   "MS Sans Serif"
      FontSize        =   9.75
      FontStrikethru  =   0   'False
      FontUnderline   =   0   'False
      Height          =   255
      Left            =   2040
      TabIndex        =   15
      Top             =   840
      Width           =   495
   End
   Begin Label Label2
      Alignment       =   1  'Right Justify
      AutoSize        =   -1  'True
      Caption         =   "Employee Name:"
      FontBold        =   -1  'True
      FontItalic      =   0   'False
      FontName        =   "MS Sans Serif"
      FontSize        =   9.75
      FontStrikethru  =   0   'False
      FontUnderline   =   0   'False
      Height          =   255
      Left            =   720
      TabIndex        =   14
      Top             =   480
      Width           =   1815
   End
   Begin Label Label1
      Alignment       =   1  'Right Justify
      AutoSize        =   -1  'True
      Caption         =   "Employee Number:"
      FontBold        =   -1  'True
      FontItalic      =   0   'False
      FontName        =   "MS Sans Serif"
      FontSize        =   9.75
      FontStrikethru  =   0   'False
      FontUnderline   =   0   'False
      Height          =   255
      Left            =   480
      TabIndex        =   13
      Top             =   120
      Width           =   2055
   End
   Begin Menu mExit
      Caption         =   "E&xit!"
   End
End

Sub cmdExit_Click ()

End Sub

Sub cmdFirst_Click ()
 EmpData.Recordset.DbMoveFirst
End Sub

Sub cmdLast_Click ()
 EmpData.Recordset.DbMoveLast
End Sub

Sub cmdNext_Click ()

  EmpData.Recordset.DbMoveNext

End Sub

Sub cmdPrevious_Click ()

  EmpData.Recordset.DbMovePrevious

End Sub

Sub EmpData_Reposition ()

 If EmpData.Recordset.BOF = True Then
  MsgBox WarnFirstEmp$
  EmpData.Recordset.DbMoveFirst
 End If

 If EmpData.Recordset.EOF = True Then
  MsgBox WarnLastEmp$
  EmpData.Recordset.DbMoveLast
 End If


End Sub

Sub Form_Load ()

 EmpData.Connect = Connect$
 EmpData.DatabaseName = DatabaseName$
 EmpData.RecordSource = EmpQuery$
 EmpData.Refresh

End Sub

Sub mExit_Click ()
 End
End Sub