frmreportstudentfees.frm

This project is developed for school management system in vb and sql server 2000. All source code in

VERSION 5.00
Begin VB.Form frmReportStudentFees 
   AutoRedraw      =   -1  'True
   BackColor       =   &H80000004&
   Caption         =   "Student..."
   ClientHeight    =   5055
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   6885
   BeginProperty Font 
      Name            =   "Tahoma"
      Size            =   8.25
      Charset         =   0
      Weight          =   400
      Underline       =   0   'False
      Italic          =   0   'False
      Strikethrough   =   0   'False
   EndProperty
   Icon            =   "frmReportStudentFees.frx":0000
   LinkTopic       =   "Form1"
   MDIChild        =   -1  'True
   ScaleHeight     =   5055
   ScaleWidth      =   6885
   WindowState     =   2  'Maximized
   Begin VB.PictureBox Picture3 
      Height          =   1575
      Left            =   -120
      Picture         =   "frmReportStudentFees.frx":000C
      ScaleHeight     =   1515
      ScaleWidth      =   12060
      TabIndex        =   9
      Top             =   -120
      Width           =   12120
      Begin VB.Label Label4 
         AutoSize        =   -1  'True
         BackStyle       =   0  'Transparent
         Caption         =   "Students Fees  Report"
         BeginProperty Font 
            Name            =   "Verdana"
            Size            =   24
            Charset         =   0
            Weight          =   700
            Underline       =   0   'False
            Italic          =   -1  'True
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H80000006&
         Height          =   570
         Left            =   2160
         TabIndex        =   10
         Top             =   360
         Width           =   5955
      End
   End
   Begin VB.PictureBox p 
      Appearance      =   0  'Flat
      BackColor       =   &H80000004&
      ForeColor       =   &H80000008&
      Height          =   525
      Left            =   3480
      ScaleHeight     =   495
      ScaleWidth      =   2985
      TabIndex        =   5
      Top             =   4800
      Width           =   3015
      Begin VB.CommandButton cmdOK 
         Caption         =   "&Preview.."
         Height          =   315
         Left            =   210
         TabIndex        =   7
         Top             =   90
         Width           =   1185
      End
      Begin VB.CommandButton Command2 
         Caption         =   "Cancel"
         Height          =   315
         Left            =   1590
         TabIndex        =   6
         Top             =   90
         Width           =   1185
      End
   End
   Begin VB.Frame Frame1 
      BackColor       =   &H80000004&
      Height          =   1725
      Left            =   2040
      TabIndex        =   0
      Top             =   2160
      Width           =   4575
      Begin VB.TextBox T 
         Enabled         =   0   'False
         Height          =   315
         Left            =   2490
         TabIndex        =   8
         Top             =   1170
         Width           =   1755
      End
      Begin VB.ComboBox cmbCourse 
         Enabled         =   0   'False
         Height          =   315
         Left            =   360
         Style           =   2  'Dropdown List
         TabIndex        =   4
         Top             =   1170
         Width           =   1875
      End
      Begin VB.OptionButton Option3 
         BackColor       =   &H80000004&
         Caption         =   "By Class And &Session"
         ForeColor       =   &H00000000&
         Height          =   315
         Left            =   2340
         TabIndex        =   3
         Top             =   690
         Width           =   1905
      End
      Begin VB.OptionButton Option2 
         BackColor       =   &H80000004&
         Caption         =   "By &Class"
         ForeColor       =   &H00000000&
         Height          =   315
         Left            =   360
         TabIndex        =   2
         Top             =   690
         Width           =   1785
      End
      Begin VB.OptionButton Option1 
         BackColor       =   &H80000004&
         Caption         =   "Show &All"
         ForeColor       =   &H00000000&
         Height          =   225
         Left            =   360
         TabIndex        =   1
         Top             =   360
         Value           =   -1  'True
         Width           =   1395
      End
   End
End
Attribute VB_Name = "frmReportStudentFees"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim sx As Long
Private Sub cmbCourse_KeyDown(KeyCode As Integer, Shift As Integer)
If T.Enabled = True Then
 If KeyCode = 13 Then
   T.SetFocus
 End If
Else
 cmdOK_Click
End If
End Sub

Private Sub cmdOK_Click()
Dim rs As New ADODB.Recordset
Dim SS As String
SS = "select VoucherNo as [Voucher No],fees.Stud_Id as [Student Roll No],student.name as [Student Name],fees.feedate as [Fee Date],fees.semester as [Semester No],student.T_FEE as [Totol Fee],fees.feeamount as [Fee padid],fees.feeamount- student.T_FEE as [Balance] from fees LEFT JOIN student ON FEES.STUD_ID=student.STUD_ID"

rs.Open SS, frmMain.Cn, adOpenKeyset, adLockOptimistic

sx = cmbCourse.ItemData(cmbCourse.ListIndex)
' If Option1.Value = True Then
'    Call ShowReport(1, 1, "Dec-2005")
' ElseIf Option2.Value = True Then
'    Call ShowReport(2, sx, "Dec-2005")
' ElseIf Option3.Value = True Then
'    Call ShowReport(3, sx, T.Text)
' End If







End Sub

Private Sub Command2_Click()
Unload Me
End Sub

Private Sub Form_Load()
Dither Me
 Call ShowCourse(cmbCourse)
 cmbCourse.ListIndex = 0
End Sub


Private Sub Option1_Click()
cmbCourse.Enabled = False
T.Enabled = False
End Sub

Private Sub Option2_Click()
    cmbCourse.Enabled = True
    cmbCourse.SetFocus
    T.Enabled = False
  End Sub

Private Sub Option3_Click()
cmbCourse.Enabled = True
T.Enabled = True
cmbCourse.SetFocus
End Sub

Public Sub ShowReport(Choice As Integer, Course As Long, Session As String)
Unload Me
 With DE.rsrptStudent_Grouping
   If .State = 1 Then .Close
     Call DE.rptStudent_Grouping(Choice, Course, Session)
     If .RecordCount = 0 Then
      MsgBox "No Match record found. Canceling report..", vbInformation, App.Comments
      Exit Sub
     End If
    rptStudents.Show
End With
End Sub