formquery.frm

基于Visual Basic 6.0 与Access 2003的学籍管理系统,可以实现许多功能

      TabIndex        =   4
      Text            =   "Text1"
      Top             =   2640
      Width           =   1935
   End
   Begin VB.TextBox txtNative 
      DataField       =   "Native"
      DataSource      =   "dataStudent"
      Height          =   375
      Left            =   8040
      MaxLength       =   20
      TabIndex        =   3
      Text            =   "Text1"
      Top             =   2640
      Width           =   3375
   End
   Begin VB.TextBox txtStudent 
      Height          =   375
      Left            =   840
      MaxLength       =   8
      TabIndex        =   1
      Text            =   "Text1"
      Top             =   840
      Width           =   1935
   End
   Begin VB.Label Label10 
      Caption         =   "班主任"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   6960
      TabIndex        =   17
      Top             =   2040
      Width           =   855
   End
   Begin VB.Label Label9 
      Caption         =   "所在班级"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   6960
      TabIndex        =   14
      Top             =   1440
      Width           =   855
   End
   Begin VB.Label Label8 
      Caption         =   "所属院系"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   6960
      TabIndex        =   13
      Top             =   840
      Width           =   855
   End
   Begin VB.Label Label5 
      Caption         =   "学号"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   3480
      TabIndex        =   12
      Top             =   840
      Width           =   495
   End
   Begin VB.Label Label3 
      Caption         =   "姓名"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   3480
      TabIndex        =   11
      Top             =   1440
      Width           =   495
   End
   Begin VB.Label Label4 
      Caption         =   "性别"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   3480
      TabIndex        =   10
      Top             =   2040
      Width           =   495
   End
   Begin VB.Label Label6 
      Caption         =   "出生日期"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   3120
      TabIndex        =   9
      Top             =   2640
      Width           =   855
   End
   Begin VB.Label Label7 
      Caption         =   "籍贯"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   7080
      TabIndex        =   8
      Top             =   2640
      Width           =   495
   End
   Begin VB.Label Label2 
      Caption         =   "学生个人信息"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   3000
      TabIndex        =   2
      Top             =   480
      Width           =   1335
   End
   Begin VB.Label Label1 
      Caption         =   "请输入学号"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   255
      Left            =   840
      TabIndex        =   0
      Top             =   480
      Width           =   1095
   End
End
Attribute VB_Name = "frmQuery"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub cmdOK_Click()

'strSQL = "SELECT * FROM Student , Class ,Department "

'txtStudentID.Text = " SELECT * FROM Student WHERE StudentID = '" & txtStudent.Text & "'"

strSQL = "SELECT *,*,DepartName, Master FROM Student,Class,Department WHERE Student.ClassID = Class.ClassID AND Class.DepartID = Department.DepartID AND StudentID ='" & txtStudent.Text & "'"

dataStudent.RecordSource = strSQL
 
dataChange.RecordSource = " SELECT * FROM Change WHERE StudentID = '" & txtStudent.Text & "'"

dataReward.RecordSource = " SELECT * FROM Reward WHERE StudentID = '" & txtStudent.Text & "'"

dataPunish.RecordSource = " SELECT * FROM Punish WHERE StudentID = '" & txtStudent.Text & "'"

'strSQL = "SELECT * FROM Student WHERE

dataStudent.Refresh

dataChange.Refresh

dataReward.Refresh

dataPunish.Refresh

End Sub

Private Sub cmdQuit_Click()

Unload Me

End Sub

Private Sub Form_Load()

dataStudent.DatabaseName = App.Path & "\StudentMIS.mdb"

dataChange.DatabaseName = App.Path & "\StudentMIS.mdb"

dataReward.DatabaseName = App.Path & "\StudentMIS.mdb"

dataPunish.DatabaseName = App.Path & "\StudentMIS.mdb"

txtStudent.Text = ""

End Sub