frm_rptemployeesalary.frm

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

VERSION 5.00
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Begin VB.Form frm_rptEmployeeSalary 
   BorderStyle     =   1  'Fixed Single
   ClientHeight    =   5235
   ClientLeft      =   45
   ClientTop       =   435
   ClientWidth     =   8790
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   5235
   ScaleWidth      =   8790
   Begin VB.Frame Frame1 
      Height          =   3015
      Left            =   360
      TabIndex        =   2
      Top             =   1800
      Width           =   8055
      Begin VB.ComboBox cmb_employeeid 
         Height          =   315
         Left            =   3120
         Style           =   2  'Dropdown List
         TabIndex        =   7
         Top             =   360
         Width           =   2535
      End
      Begin VB.CommandButton Command1 
         Caption         =   "Show"
         Height          =   495
         Left            =   2280
         TabIndex        =   5
         Top             =   2040
         Width           =   2535
      End
      Begin MSComCtl2.DTPicker dt_date 
         Height          =   375
         Left            =   3120
         TabIndex        =   4
         Top             =   1080
         Width           =   3015
         _ExtentX        =   5318
         _ExtentY        =   661
         _Version        =   393216
         Format          =   48955393
         CurrentDate     =   38825
      End
      Begin VB.Label Label2 
         Caption         =   "Select Employee Id"
         Height          =   255
         Left            =   360
         TabIndex        =   6
         Top             =   360
         Width           =   1455
      End
      Begin VB.Label Label1 
         Caption         =   "Select Salary For Month and Year"
         Height          =   375
         Left            =   360
         TabIndex        =   3
         Top             =   1080
         Width           =   2535
      End
   End
   Begin VB.PictureBox Picture3 
      Height          =   1575
      Left            =   -120
      Picture         =   "frm_rptEmployeeSalary.frx":0000
      ScaleHeight     =   1515
      ScaleWidth      =   11955
      TabIndex        =   0
      Top             =   -120
      Width           =   12015
      Begin VB.Label Label4 
         AutoSize        =   -1  'True
         BackStyle       =   0  'Transparent
         Caption         =   "Select Employee Salary Slip"
         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            =   1200
         TabIndex        =   1
         Top             =   360
         Width           =   7455
      End
   End
End
Attribute VB_Name = "frm_rptEmployeeSalary"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Dim Rs As New ADODB.Recordset
If (Trim(cmb_employeeid.Text) = "All Employees") Then
Rs.Open "select * from qry_EmployeeSalary where ForMonth=" & Month(dt_date.Value) & " and ForYear=" & Year(dt_date.Value), frmMain.Cn, 2, 3
Else
Rs.Open "select * from qry_EmployeeSalary where ForMonth=" & Month(dt_date.Value) & " and ForYear=" & Year(dt_date.Value) & " and Employeeid=" & Val(cmb_employeeid.Text), frmMain.Cn, 2, 3
End If
Set rptEmplopyeeSalary.DataSource = Rs
rptEmplopyeeSalary.Show
Unload Me


End Sub

Private Sub Form_Load()
Dim Rs As New ADODB.Recordset

Rs.Open "select * from qry_EmployeeSalary where ForMonth=" & Month(dt_date.Value) & " and ForYear=" & Year(dt_date.Value), frmMain.Cn, 2, 3

cmb_employeeid.Clear
Do While Not Rs.EOF
cmb_employeeid.AddItem Rs!employeeid
Rs.MoveNext

Loop
cmb_employeeid.AddItem "All Employees"
Rs.Close
End Sub