How to an attendance role (2002 SP3)

**Peter Kinross** · 2006-02-12 10:13

Anyone have any idea how to show an attendance role that looks like a plain ordinary paper role looks. I.e., with names in the left column and MeetDates as top rows, and some method of showing attendance. The one I have built shows asterisks for attendance by double clicking.
The role would be based on say:
tblPeople:- PersID, Name.
tblMeets; MeetID, MeetDate.
tblPeopleMeetsLink; MeetID, PersID
I have previously done it by building the form's rows, cols & content by code. However, it takes a large amount of laborious hand measuring and coding for each individual control. I was hoping that there would be a more sophisticated (simple) way of doing it. I

**HansV** · 2006-02-12 10:28

If it's for display only, you could create a crosstab query.
If it's for data entry, it will always be laborious. Excel is much better suited for this.

**Peter Kinross** · 2006-02-12 11:52

Thanks Hans, I was afraid of that. It's for data entry.
I have sent Db data to Excel from Access quite often, but never sent the data to Excel where it can be edited then back to Access. I assume that the two can be linked to work like that? At a guess I supose that the underlying Access query could become the data source for an Excel workbook? To save me re-inventing the wheel, would you know of any references that explain how it's done?

**HansV** · 2006-02-12 12:04

Do you really need the data in Access? I would forego Access entirely and create the entire application in Excel.

**Peter Kinross** · 2006-02-12 20:09

Oh yeah. It's part of an existing admin program for a 1400 member church. The role is for the kids part of that church. So all the kids data is part of the whole Db.

**HansV** · 2006-02-12 20:36

Then I'd stick with the laborious method you already have. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

**Peter Kinross** · 2006-02-12 20:38

Thanks old son. I respect your wisdom.

Thread: How to an attendance role (2002 SP3)

Thread Tools