Help! need to make attendance form!

[darksniper]

I am trying to make a class attendance form, where user chooses classType
ex:"English, French" then the program shows all of the students from tblStudents that are enregistered in that class. And some how make it so that user could select on or many users in the same class and press add button which will add the students into attendance table for the current class and the current day,

**Allso what I would like to do if possible after the form above works, is to if the student has been allready added for the current day, the check box becomes un editable with appropriable comment in the comments line for that student or for examples the student registered for 12 classes, the attendance keeps track of the classes and when the student tryed to go to 13'th class the check box is uneditable and in the comments line for that student metions the reases.

 

[gromit]

Hi -

What you are looking to do is probably best done with some VBA (visual basic).

You can use the AfterUpdate property of the class type to launch a query. The query would look for the students in that class and populate a listbox. You can then select items from the listbox and click a button to print those records as a report or add to a temporary table etc.

Not sure how much VBA programming you've done, so if none of this makes sense, it will take more time and effort.

- g

 

[darksniper]

it will take more time and effort.

Well everething takes time and effort, right now I am having trouble making the form to show students for the current selected class. It either shows one student in the list or shows one class. I can attach the mdb if it will help. Allso I am not good in vb, I just programm java. And allso as I have mentionned ** section is something that I would like to have , but it is not really required. it is just the top section of my message is the most impostant part.

 

[gromit]

If you want to show students for the current selected class, you should be able to create a form and a subform. The main form would have the control to select the class and the subform can show students (in continous view). Be sure to set up a parent / child relationship on the class field.

 

[darksniper]

i'll try that,

 

[Surfette]

Hi Gromit and Darksniper,

Would you both please explain how you are attempting this in more detail? I'm trying to create an attendace form (similar to Darksniper) as well. I would like the form to open up, the teacher would pick the class that they are in. Once they select their class from the drop down menu, then information for that class will come up. They can choose to take attendance or enter in the grades for that class.

Right now I'm having trouble getting the two forms to link up. When the person selects the class on the first form, the second form isn't pulling up information for that class only. I could really use some help. I've never done VBA before or any sort of programming.

Thanks in advance.

Surfette

 

[darksniper]

first, you need to have a subform,

so in other words, you have a table with classes, like English Id=1, French id=2, etc.
and you attendance form, has a table that should have
following fields->
attendanceID <<PK>>
classID
studentID
etc..

so you when you make a subform you link the class id from from where you choose classes, to the classID where you do the attendance