R
rwmorton
I am doing a database for an after school daycare program. They want
to know at all times where a student is at. There are three table,
student, a list of student names and ID numbers, activity, a list of
activities and locations and short code for htme, and lastly inout, a
record of the students as they are checked in and out. For time I used
a time mask and type.
The forms are simple enough for the student add and activity add. I
tinkered around with the sign in form to get it to work. When a user
enters a student number it adds that to the table and automatically
enters the time in the time in. I also add to the timeout a null (more
on that later). When they get all done (choosing activity and
verifying name is right, the record is added.
The time out form was a bit trickier. I orignally set up a query that
would ask for the student ID and then look for that record in the inout
table if it had a NULL entry in timeout. When using time it seems you
can not search for a non-zero value. Since it could theoretically
return one entry it seemed the best idea. Unfortunately this would not
allow for the data to be changed. I then switch to a query that would
find all the NULL entried in timeout and used a dropdown menu so that
the user would be able to find the right student. It seems to work OK,
but no matter what I try the =NOW() function will not change the
timeout. I have tried getfocus, loose focus, onenter, etc. Is there a
way to update this value to the current time without making the user
enter it?
Any help would be appreciated, thanks..
R Morton
to know at all times where a student is at. There are three table,
student, a list of student names and ID numbers, activity, a list of
activities and locations and short code for htme, and lastly inout, a
record of the students as they are checked in and out. For time I used
a time mask and type.
The forms are simple enough for the student add and activity add. I
tinkered around with the sign in form to get it to work. When a user
enters a student number it adds that to the table and automatically
enters the time in the time in. I also add to the timeout a null (more
on that later). When they get all done (choosing activity and
verifying name is right, the record is added.
The time out form was a bit trickier. I orignally set up a query that
would ask for the student ID and then look for that record in the inout
table if it had a NULL entry in timeout. When using time it seems you
can not search for a non-zero value. Since it could theoretically
return one entry it seemed the best idea. Unfortunately this would not
allow for the data to be changed. I then switch to a query that would
find all the NULL entried in timeout and used a dropdown menu so that
the user would be able to find the right student. It seems to work OK,
but no matter what I try the =NOW() function will not change the
timeout. I have tried getfocus, loose focus, onenter, etc. Is there a
way to update this value to the current time without making the user
enter it?
Any help would be appreciated, thanks..
R Morton