Scribd Logo
Upload

Welcome to Scribd!

  • 1K views

    Student Mark Analysis System

    Uploaded by

    sumitjangir756
    This document describes the coding for a student mark analysis system with 4 forms. Form1 allows login for students or faculty. Form2 is the faculty interface with options to cancel or access Form3. Form3 is the main interface, allowing a faculty user to add, delete, search for, and navigate student records stored in a database table. Form4 allows searching for a student record by ID number.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd

    Student Mark Analysis System

    Uploaded by

    sumitjangir756
    1K views8 pages
    This document describes the coding for a student mark analysis system with 4 forms. Form1 allows login for students or faculty. Form2 is the faculty interface with options to cancel or access Form3. Form3 is the main interface, allowing a faculty user to add, delete, search for, and navigate student records stored in a database table. Form4 allows searching for a student record by ID number.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document describes the coding for a student mark analysis system with 4 forms. Form1 allows login for students or faculty. Form2 is the faculty interface with options to cancel or access Form3. Form3 is the main interface, allowing a faculty user to add, delete, search for, and navigate student records stored in a database table. Form4 allows searching for a student record by ID number.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    1K views8 pages

    Student Mark Analysis System

    Uploaded by

    sumitjangir756
    This document describes the coding for a student mark analysis system with 4 forms. Form1 allows login for students or faculty. Form2 is the faculty interface with options to cancel or access Form3. Form3 is the main interface, allowing a faculty user to add, delete, search for, and navigate student records stored in a database table. Form4 allows searching for a student record by ID number.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 8

    STUDENT MARK ANALYSIS SYSTEM

    FORM1 CODING: Private Sub STUDENTLOGIN_Click(Index As Integer) Form4.Show End Sub Private Sub FACULTYLOGIN_Click(Index As Integer) Form2.Show End Sub

    FORM2:

    FORM2 CODING: Private Sub Cancel_Click(Index As Integer) Form1.Show End Sub Private Sub ok_Click() If Text1.Text = "USER" And Text2.Text = "PASS" Then Form3.Show Else

    MsgBox "INVALID ID" End If End Sub FORM3:

    FORM3 CODING: Private Sub ADDNEW_Click() Data1.Recordset.ADDNEW End Sub

    Private Sub Command1_Click()

    If Data1.Recordset.BOF = True Then MsgBox "FirstRecord" End If Data1.Recordset.MovePrevious End Sub

    Private Sub DELETE_Click() Data1.Recordset.DELETE Data1.Recordset.MoveNext End Sub

    Private Sub INSERT_Click() Data1.Recordset.Update End Sub

    Private Sub NEXT_Click() Data1.Recordset.MoveNext If Data1.Recordset.EOF = True Then MsgBox "LastRecord"

    End If End Sub

    Private Sub search_Click() Dim a As String If Not Data1.Recordset.BOF Then Data1.Recordset.MoveFirst a = InputBox("ENTER STUDENT ID") Data1.Recordset.FindFirst ("STUDENTID =" & a) If Data1.Recordset.EOF = True Then MsgBox "RECORD NOT FOUND" Else End If End If End Sub

    FORM3:

    FORM4:

    FORM4 CODING: Private Sub Command1_Click() If Not Data1.Recordset.BOF Then Data1.Recordset.MoveFirst a = Text1.Text Data1.Recordset.FindFirst ("STUDENTID =" & a) If Data1.Recordset.EOF = True Then MsgBox "RECORD NOT FOUND" Else End If End If End Sub

    You might also like