I'm trying to build a database for my Girl Scout troop. I have lots of grand ideas and plans, and hope to learn Access and VBA along the way. But I'm having problems getting started. The book I bought shows me how to build a contact/address database, but doesn't really help me understand how to use this knowledge for other things. I want to start by being able to track attendance for our weekly meetings.
I have the following:
TableGirlInfo
GirlID (primary key)
FirstName
LastName
active (boolean)
and lots of other info such as address and phone number
TableMeetings
meetingID (primary key)
meetingdate
comments
TableAttendance
girlID
meetingID (these 2 are a joint primary key)
I am assuming I need a form, probably with a subform. What i want is a form that has a date (default to today's date) and a text area for comments about the meeting. Then it would list all the girls who are currently active, with a check box beside each name. And a "done" command button at the bottom.
I want to be able to set my laptop on a table, and as the girls come in, they will check the box beside their name. (I'm way too busy to be taking attendance!) Then after the meeting, I can add any comments, and hit done to update the attendance table.
Thanks for any guidance,
JoAnne
I have the following:
TableGirlInfo
GirlID (primary key)
FirstName
LastName
active (boolean)
and lots of other info such as address and phone number
TableMeetings
meetingID (primary key)
meetingdate
comments
TableAttendance
girlID
meetingID (these 2 are a joint primary key)
I am assuming I need a form, probably with a subform. What i want is a form that has a date (default to today's date) and a text area for comments about the meeting. Then it would list all the girls who are currently active, with a check box beside each name. And a "done" command button at the bottom.
I want to be able to set my laptop on a table, and as the girls come in, they will check the box beside their name. (I'm way too busy to be taking attendance!) Then after the meeting, I can add any comments, and hit done to update the attendance table.
Thanks for any guidance,
JoAnne