recordsets related questions

[roger]

Hello Friends:

I have a table which keeps a track of all the training
sessions for computer based training that a student has
had and then I have an another table in which the
adminstrator for this training program would have the
ability to store exemptions for these students.

So for eg. if a the student is schedlued to take a class
on say Tuesday at 10-12 AM and if that Tuesday is a
holiday the admin would give an exemption for that
student. What I want to do is write recordset code where
it will look at what the exemptions are and accordingly
grant the exemptios to these students. That way the admin
can give exemptions for say 1 day and it will
automatically grant exemptions to all the students who
were scheduled for that day.

Is there an other way to do these?

 

[Gary Miller]

Roger,

You haven't really said how you are flagging the exemption
or the structure of your class schedule, but one approach
would be to create an Update Query that relates that class
to the enrolled students and have it update the excemption
flag. You could set the query up for constant reuse by
referring to a class selection control on a form for it's
criteria

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[roger]

Thanks for your help.

Yes I do have a table with attendance and so what I can do
is every week Friday I can run an update query on these
records and that way I can update these records.

Will the update query though let the user choose like
which student numbers to select at run time or to selct
ALL at run time? How would I do that

 

[Gary Miller]

Originally you were asking for a way to update all of the
students for a particular scheduled class that was
cancelled/postponed. Are you asking now if you can have the
query now prompt you on each student? No, a query wouldn't
do that although there would be methods to do it with VBA.
You would get all the students for the class unless you
wanted to specify them individually which I thought that you
were already doing.

I suppose that you could create a subform that would list
all of the students for a class where you could scroll
through them and mark the ones that you want exempt.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________