Attendance Roster - Few questions (query msg, add one record, auto fill date)

chellebell1689

Registered User.
Local time
Yesterday, 21:00
Joined
Mar 23, 2015
Messages
267
Hello,
I have a SS attendance form that is based on a table. The members are added to the table via a query that looks for those who are on the roster (field: On_Roll = True). The query generates every time the form is opened, and the form only shows the records that have an empty date field.

Here are my questions (and if need be, I will separate the questions)
1) How do I tell the system not to ask if the query can run (obviously I want it to run)?

2) I would like a pop-up to show when the form first opens, the pop-up will ask for the date (of the previous Sunday or which ever Sunday they are taking roll for). After they fill that in and hit enter (or whatever) it will automatically fill in the date field for each record. This would save a little time vs adding the date to every member of each class (we have 15 classes, with at least 10-15 members).

3) So I do have the form set up so they can either add a visitor or look up someone already in the system to add to the roster, but my problem is I don't know how to tell the system to add just that one record. I thought about adding a button to say "Add To Roll" and it would tell the query to run just for that record, but I don't know how to tell a query to run for only one record and I don't know how to refresh the form to show the added member, but not re-add every person all over again.

**EDIT**
So upon thinking more about how to "refresh" the form, I've decided to create a button the user will click for a new week/Sunday. This way the form will open and show all the information (as well as all the members added), but not re-add everyone. Once the button is clicked it will filter out the records with the date filled in and re-add everyone.


Thank you in advance and please let me know if you need more information.
 
Last edited:
1) docmd.SetWarnings True or False. False suppresses warning.
2) i would build a temporary table of Sundays, each time the form is opened, and allow the user to pick the correct one via combo box on the form.
3) Each time a visitor name is specified, check the underlying table to see if it already exists and act accordingly.
 

Users who are viewing this thread

Back
Top Bottom