Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to an attendance role (2002 SP3)

    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
    Regards,
    Peter

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How to an attendance role (2002 SP3)

    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.

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to an attendance role (2002 SP3)

    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?
    Regards,
    Peter

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How to an attendance role (2002 SP3)

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

  5. #5
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to an attendance role (2002 SP3)

    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.
    Regards,
    Peter

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How to an attendance role (2002 SP3)

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

  7. #7
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    637
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to an attendance role (2002 SP3)

    Thanks old son. I respect your wisdom.
    Regards,
    Peter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •