frm教师表.frm

教师科研系统 教师科研系统 教师科研系统

VERSION 5.00
Object = "{67397AA1-7FB1-11D0-B148-00A0C922E820}#6.0#0"; "MSADODC.OCX"
Begin VB.Form frm科研人员简历表 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "科研人员简历表"
   ClientHeight    =   3960
   ClientLeft      =   1095
   ClientTop       =   435
   ClientWidth     =   6660
   KeyPreview      =   -1  'True
   LinkTopic       =   "Form6"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   3960
   ScaleWidth      =   6660
   Begin VB.PictureBox picButtons 
      Align           =   2  'Align Bottom
      Appearance      =   0  'Flat
      BorderStyle     =   0  'None
      ForeColor       =   &H80000008&
      Height          =   300
      Left            =   0
      ScaleHeight     =   300
      ScaleWidth      =   6660
      TabIndex        =   10
      Top             =   3330
      Width           =   6660
      Begin VB.CommandButton cmdClose 
         Caption         =   "关闭"
         Height          =   300
         Left            =   3521
         TabIndex        =   12
         Top             =   0
         Width           =   1095
      End
      Begin VB.CommandButton cmdAdd 
         Caption         =   "录入"
         Height          =   300
         Left            =   1213
         TabIndex        =   11
         Top             =   0
         Width           =   1095
      End
   End
   Begin VB.TextBox txtFields 
      DataField       =   "著作"
      DataSource      =   "datPrimaryRS"
      Height          =   645
      Index           =   4
      Left            =   4560
      TabIndex        =   9
      Top             =   1920
      Width           =   1695
   End
   Begin VB.TextBox txtFields 
      DataField       =   "相关论文"
      DataSource      =   "datPrimaryRS"
      Height          =   645
      Index           =   3
      Left            =   1440
      TabIndex        =   7
      Top             =   2280
      Width           =   1695
   End
   Begin VB.TextBox txtFields 
      DataField       =   "所带课题"
      DataSource      =   "datPrimaryRS"
      Height          =   645
      Index           =   2
      Left            =   4560
      TabIndex        =   5
      Top             =   840
      Width           =   1695
   End
   Begin VB.TextBox txtFields 
      DataField       =   "教师名"
      DataSource      =   "datPrimaryRS"
      Height          =   645
      Index           =   1
      Left            =   1440
      TabIndex        =   3
      Top             =   1320
      Width           =   1695
   End
   Begin VB.TextBox txtFields 
      DataField       =   "教师号"
      DataSource      =   "datPrimaryRS"
      Height          =   645
      Index           =   0
      Left            =   1440
      TabIndex        =   1
      Top             =   360
      Width           =   1695
   End
   Begin MSAdodcLib.Adodc datPrimaryRS 
      Align           =   2  'Align Bottom
      Height          =   330
      Left            =   0
      Top             =   3630
      Width           =   6660
      _ExtentX        =   11748
      _ExtentY        =   582
      ConnectMode     =   0
      CursorLocation  =   3
      IsolationLevel  =   -1
      ConnectionTimeout=   15
      CommandTimeout  =   30
      CursorType      =   3
      LockType        =   3
      CommandType     =   2
      CursorOptions   =   0
      CacheSize       =   50
      MaxRecords      =   0
      BOFAction       =   0
      EOFAction       =   0
      ConnectStringType=   1
      Appearance      =   1
      BackColor       =   -2147483643
      ForeColor       =   -2147483640
      Orientation     =   0
      Enabled         =   -1
      Connect         =   "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=C:\Documents and Settings\518\桌面\新建文件夹 (2)\东.mdb"
      OLEDBString     =   "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=C:\Documents and Settings\518\桌面\新建文件夹 (2)\东.mdb"
      OLEDBFile       =   ""
      DataSourceName  =   ""
      OtherAttributes =   ""
      UserName        =   ""
      Password        =   ""
      RecordSource    =   "科研人员简历表"
      Caption         =   " "
      BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      _Version        =   393216
   End
   Begin VB.Label lblLabels 
      Caption         =   "著作:"
      Height          =   255
      Index           =   4
      Left            =   3840
      TabIndex        =   8
      Top             =   2040
      Width           =   1815
   End
   Begin VB.Label lblLabels 
      Caption         =   "相关论文:"
      Height          =   255
      Index           =   3
      Left            =   360
      TabIndex        =   6
      Top             =   2520
      Width           =   1455
   End
   Begin VB.Label lblLabels 
      Caption         =   "所带课题:"
      Height          =   255
      Index           =   2
      Left            =   3600
      TabIndex        =   4
      Top             =   1080
      Width           =   1815
   End
   Begin VB.Label lblLabels 
      Caption         =   "教师名:"
      Height          =   255
      Index           =   1
      Left            =   360
      TabIndex        =   2
      Top             =   1440
      Width           =   1815
   End
   Begin VB.Label lblLabels 
      Caption         =   "教师号:"
      Height          =   255
      Index           =   0
      Left            =   360
      TabIndex        =   0
      Top             =   480
      Width           =   1815
   End
End
Attribute VB_Name = "frm科研人员简历表"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub Form_Unload(Cancel As Integer)
  Screen.MousePointer = vbDefault
End Sub

Private Sub datPrimaryRS_Error(ByVal ErrorNumber As Long, Description As String, ByVal Scode As Long, ByVal Source As String, ByVal HelpFile As String, ByVal HelpContext As Long, fCancelDisplay As Boolean)
  '错误处理程序代码置于此处
  '想要忽略错误，注释掉下一行
  '想要捕获它们，在此添加代码以处理它们
  MsgBox "Data error event hit err:" & Description
End Sub

Private Sub datPrimaryRS_MoveComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
  '为这个 recordset 显示当前记录位置
  datPrimaryRS.Caption = "Record: " & CStr(datPrimaryRS.Recordset.AbsolutePosition)
End Sub

Private Sub datPrimaryRS_WillChangeRecord(ByVal adReason As ADODB.EventReasonEnum, ByVal cRecords As Long, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
  '验证代码置于此处
  '下列动作发生时该事件被调用
  Dim bCancel As Boolean

  Select Case adReason
  Case adRsnAddNew
  Case adRsnClose
  Case adRsnDelete
  Case adRsnFirstChange
  Case adRsnMove
  Case adRsnRequery
  Case adRsnResynch
  Case adRsnUndoAddNew
  Case adRsnUndoDelete
  Case adRsnUndoUpdate
  Case adRsnUpdate
  End Select

  If bCancel Then adStatus = adStatusCancel
End Sub

Private Sub cmdAdd_Click()
  On Error GoTo AddErr
  datPrimaryRS.Recordset.AddNew

  Exit Sub
AddErr:
  MsgBox Err.Description
End Sub

Private Sub cmdUpdate_Click()
  On Error GoTo UpdateErr

  datPrimaryRS.Recordset.UpdateBatch adAffectAll
  Exit Sub
UpdateErr:
  MsgBox Err.Description
End Sub

Private Sub cmdClose_Click()
  Unload Me
End Sub