Recent content by kirtney

This is the database the name of the form is application. in the courses subform you would see that I can only enter on one course. Here i would ideally like to be able to provide the users with 4 drop down boxes so that they could enter data

I was able to fix that problem thanks so much for the help. The issue that I am running into now is in the sub form have created i want to be able to put multiple drop down boxes so that the students can choose the subjects they wish to do . The thing that is happening now is that when i select...

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...

Gemma interesting idea I never looked at the continous form option. hmmm. The reason why i used the cascading combo boxes is because I am trying to minimize the number of errors they could possibly make by limiting them to dealing with seeing one record at a time.

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...

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...

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...

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...

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...

Thanks very much

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...

Thanks very much i will test it out

all the student information is stored in a table. they are all automatically promoted every year. All i really need the database to so is automatically promote each student from one class to another (for example from grade 11 to grade 12 ). Once this is done i can then assign classes to a group...

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...