Forum Discussion
toggle controls to create pivot table?
"I want to be able to have a column/field that is just a check mark or toggle in each cell that is selected if the individual needs that form. (like a blood sugar record for diabetics) so then I can have a pivot table that is only for diabetic monitoring that I can then use with word to mail merge. I see the add controls from developer tab, but it seems like a clunky way to insert the control into the cell so I'm wondering if there is a better way to do this. I have around 75 different forms that are used for the 37 individuals or the 8 houses we have. I would like to make setting this up as painless as possible and then the running/printing as efficient too. So Ideally, what i want is to be able to pick house 1 , have a table created that gives me all the individuals who live in that house and what documentation requirements each individual has. "
The easiest way for you to create a solution for this is in MS Access. You can create a list database and include an attachment field. Once you populate your database, you can also attach the document file within the person's record. You then create a form using the wizard, then add a button to print all the attached documents you have inserted into the attachment field using a macro, which i found online:
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_winother-mso_365hp/printing-multiple-attachments-in-microsoft-access/ea80217f-f0ed-4006-a994-9949af33069b
cheers