Subquery/report with check boxes
in [Help]
|
Prev: Storing user preferences
Next: newbie needs examples of creating a recordset and inserting datausing it in Access 2007?
From: MrsRum on 30 May 2010 17:45 Greetings and salutations! I have a form to enter data that tracks attendance at a function. As in, this grandparent attended this seminar. I have a sub-query that shows the grandchildren connected to that grandparent. And it works great. But.... What I would actually like is a sub-form/query that instead allows me to see the list of grandkids with a check box for each grandchild so I can click in it and select the grandchildren who also attended. I want it simple like that because there will be a lot of volunteers entering data and the less they have to touch the better. (In the end, the counts of WHO attended WHAT are used to support funding/grant requests. You know, red tape.) I have tables for grandparents, grandchildren, and event attendance tracking. I'm not a programmer by any stretch, and so as a self-taught hacker I work in design view as much as possible because it's all I know. If there is a workable solution in design view I'd be grateful. If there is a coding solution then I guess I'll learn something. :) Any help or direction will be be greatly appreciated. I'm stumped and frustrated. Good reason to drink beer, but not conducive to making progress on something the non-profit wants to start testing in two weeks. Yikes. And this is the last thing I need built of course.....so close and yet so far. :))) Thank you in advance. Mrs. Rum
From: Mark Andrews on 1 Jun 2010 20:05
If you have a tables for events, grandparents, grandchildren and eventattendance and if the eventattendance table has eventid, grandparentid, grandchildid and you basically expect EITHER grandparentid OR grandchildid to be populated along with the eventid then you could use two separate subforms (one for grand parents and one for grand children) on the event screen (both are linked by the event screen) and each one has a dropdown to select a grand parent or grand child, you then add rows to add new grand parents or grand children. You can do check boxes but that would be trickier and you would need some code, subforms are designed to work that adding records adds new records to the table (without code). On another note you might want to take a look at my donation software it has event tracking and works slightly differently in that everyone is considered a contact and you can relate contacts to other contacts (so grand children can be related to their grand parent etc...) you then use contacts for all kinds of things. It might help you out with ideas, it's done in Access. There is also a simple event tracking template on Microsoft's site (it's very simple). If you have multiple people sharing a database you want to split the database and use linked tables so you have multiple front-ends (one for each user/computer) and one shared front-end. -- Mark Andrews RPT Software http://www.rptsoftware.com http://www.donationmanagementsoftware.com "MrsRum" <mrsrum(a)gmail.com> wrote in message news:a1d85858-6240-42b0-90d2-5c3b680ef88e(a)a39g2000prb.googlegroups.com... > Greetings and salutations! > > I have a form to enter data that tracks attendance at a function. As > in, this grandparent attended this seminar. I have a sub-query that > shows the grandchildren connected to that grandparent. And it works > great. But.... > > What I would actually like is a sub-form/query that instead allows me > to see the list of grandkids with a check box for each grandchild so I > can click in it and select the grandchildren who also attended. I > want it simple like that because there will be a lot of volunteers > entering data and the less they have to touch the better. (In the > end, the counts of WHO attended WHAT are used to support funding/grant > requests. You know, red tape.) > > I have tables for grandparents, grandchildren, and event attendance > tracking. > > I'm not a programmer by any stretch, and so as a self-taught hacker I > work in design view as much as possible because it's all I know. If > there is a workable solution in design view I'd be grateful. If there > is a coding solution then I guess I'll learn something. :) > > Any help or direction will be be greatly appreciated. I'm stumped and > frustrated. Good reason to drink beer, but not conducive to making > progress on something the non-profit wants to start testing in two > weeks. Yikes. And this is the last thing I need built of > course.....so close and yet so far. :))) > > Thank you in advance. > > Mrs. Rum |