It's been a while since I've been here.
I'm back at it again. I'm trying to teach myself by creating an Access database for my own personal use at home. Let's jump right into it.
My project is a Chores/Rewards database for my wife and me to use for our three kids. The current goal I have is as follows:
"lu_Chores_tbl" is a list of chores that can be done by the kids. This table acts as a lookup for forms / queries (since it also contains the points they earn for each chore). I would add to this table in the future if I come up with additional chores that need to be done.
What I would like to do is create a form that lists all of the chores in this table, but does NOT modify the contents of the table. The idea is to allow it to automatically update if I add more chores in the future. Secondly, I was wanting to display a checkbox next to each record in the form. The idea being that I could check off the chores that had been completed throughout the day.
I plan on having a combo box at the top of the form that is tied to "lu_Personnel_tbl" that has a list of the kids, and a "submit" button at the bottom of the form. When clicking submit it would go through the controls on the form, checking the check boxes, and if it is True, then it would add a record to "m_ChoresCompleted_tbl" with the person's name, the chore name, and today's date.
I may have given more info than needed, but better more than less. Is there any reference/help to the type of form I want to create?
Thank you for looking!
~Kit
I'm back at it again. I'm trying to teach myself by creating an Access database for my own personal use at home. Let's jump right into it.
My project is a Chores/Rewards database for my wife and me to use for our three kids. The current goal I have is as follows:
"lu_Chores_tbl" is a list of chores that can be done by the kids. This table acts as a lookup for forms / queries (since it also contains the points they earn for each chore). I would add to this table in the future if I come up with additional chores that need to be done.
What I would like to do is create a form that lists all of the chores in this table, but does NOT modify the contents of the table. The idea is to allow it to automatically update if I add more chores in the future. Secondly, I was wanting to display a checkbox next to each record in the form. The idea being that I could check off the chores that had been completed throughout the day.
I plan on having a combo box at the top of the form that is tied to "lu_Personnel_tbl" that has a list of the kids, and a "submit" button at the bottom of the form. When clicking submit it would go through the controls on the form, checking the check boxes, and if it is True, then it would add a record to "m_ChoresCompleted_tbl" with the person's name, the chore name, and today's date.
I may have given more info than needed, but better more than less. Is there any reference/help to the type of form I want to create?
Thank you for looking!
~Kit
