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.
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: