Annually uncheck boxes

[tgambill]

I have used Excel quite a bit and just created my first access database with tab forms. I am an Athletic Trainer and use the database to keep track of my athletes and their injuries and other related information.
My issue as follows: I have one table/form with check boxes to keep track of paperwork they need to turn in. Some items they only turn in once and others they need to turn in annually. I know very little about visual basic and I would like to create a macro that I can run at the beginning of each year that will clear all the boxes for the paperwork they need to resubmit that year for each athlete but not clear the boxes that they only have to turn in once. There are 3 boxes to clear annually for each athlete. It's really a pain to clear over 900 boxes one at a time.
Any help would be appreciated.

 

[apr pillai]

Provide a copy of your database with some sample data and the Form. I think a small VBA routine, run from a Command Button Click from the Form, can do the job.

 

[tgambill]

Thank you for your reply. I should have deleted the thread as someone I know created an update query for me.

 

[Galaxiom]

BTW

Rather than using checkboxes and reset them it would be more typical to record the date of submission of the document. A Null date entry means not submitted.

This keeps a historical record and allows the status of each submission at any date in the past too.

Databases are often structured with this transactional technique where one does not store the current state of a data point but instead can derive the state by reconstructing it from the history of changes.

Moreover, if you have a field in the table for each document you are not making the most of relational data structures. Every time you need to add a document type you must add a new field.

A different structure using a related table for this information allows new document types to be added without adding new fields.

The related table would have fields for AthleteID, DocumentID and SubmissionDate. It can be easily displayed as a subform from an Athlete or Document form.

This same table structure can be used to record a wide variety of information such as their weight, competitions, training routines and performance for example.