Insert query or Recordset

[roger]

Hello Friends:

I have 2 tables in my application.
A students table which losts all the 25 students taking
this online training program and the other table for the
attendance records of these students.

These students have sessions scheduled for them when they
do training on the computer; sometime they can get
exemptions of time off by the Training coordinator for
whatever reason such as holiday etc. In that case these
hours are not considered as used by the students and they
can get more time latter on.

I have to design a way whereby the admin can give these
students ALL or individually an exempt time. When he does
that a record must get entered in the tblattandance which
will show something like...
Stu_Clock_Num=20090,Exempt=yes,Hours_Exempt=4 hrs

How would I do that?

Can I only do it using a recordset only or can I do it
using an Insert,Update etc type of query.

 

[Ken Snell]

You could do this by either an append query (because you say you're adding a
record to the table) or via a recordset based on the table and to which you
add records.

You'd need to design a form that allows the user to either do for "all
students" or for a single student. This could be done with a form that has a
combo box control on it for selecting a student's name (or for selecting all
students), and then a command button that runs the append query or that runs
code that opens and appends to a recordset. You also could have a textbox on
the form for entering the number of hours.