Search results

  1. K

    Form Issue

    I am trying to create a form for data entry. It is purpose is to allow student to apply for multiple course as well as input their various qualifications. The list of subjects they can choose from is in the form of a drop down list. This is also the way they can choose the list of courses they...
  2. K

    Creating a Trigger

    I am designing a database that is going to be used to record student marks in a school. Due to the large number of students I was forced to create cascading combo boxes which would only show the corresponding students when a class is selected. My problem is that I need that selected Student...
  3. K

    Using a cascading combo box on a form

    Good day I am designing a database that would be used to track student grades throughout their academic life. Hence I have the following tables grade, student , class , teacher and course. For the grade table I am using a composite key which is defined as Student ID (text) Course ID (text) Term...
  4. K

    User access levels using VB

    Hi I am trying to create a password enabled database for multiple users. I was looking online and i found a way to do it but when i use the VB code that they have outlined but i keep getting this error when i run the command compile error syntax error. So i was wondering if someone can look at...
  5. K

    Can someone please check my vb script

    I am trying to link 2 combo boxes. One called ClassID (Combo0) and one called StudentName (Combo2). I followed the steps outline for the VB scripting for it and I am getting the ClassID to be a drop down field but not the StudentName. Please advise. This is the VB script I used Private Sub...
  6. K

    Cascading combo boxes

    Hi guys I am a novice user of access. I am trying to create a form that allows me have a combo box that when i select a class the next combo box shows me all the students from that class. I have gone through all the suggestions in the forum on how to do it and i am lost. The tables i am using...
  7. K

    Link 2 combo boxes

    Hey people , I am trying to link 2 combo boxes for a student database. In theory i want it to be able to select a class and the second combo box automatically show me the students assigned to that class. I tried this code but i am not sure that i wrote it right in VB. Please help Private Sub...
  8. K

    Update table question

    Guys i am building a database as a school project. It is based on a grading system that would allow teachers to store and update student examination marks. What i would like to know, is there a way i can set up the database to automatically promote students from one academic year to another? And...
Back
Top Bottom