Possibilities for Attendance-Tracking Calendar Form?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Arnold
    #1

    Possibilities for Attendance-Tracking Calendar Form?

    Hello;
    I really want to make an attendance database similar to A.D. Tejpal's
    Query_CrosstabA ttendanceMarkin g, www.rogersaccesslibrary.com/OtherLibraries.asp,
    that, in addition to storing the date & time stamp in the calendar,
    allows users to input the following in each grid cell:

    AttendanceType (P = Present (fills P by default every day), EX =
    excused, UX = unexcused, UK = unknown).
    AttendanceDetai ls (a text field for comments).
    A little In?Out togglebutton (In to be set as default for every new
    day, Out would reset the timestamp, storing the previous timestamp in
    a table to be used in time calculations of how long students are "Out"
    vs. "In").
    Plus the ability to modify former and future dates.
    Plus kitchen sink...

    The only problem is that I am new to crosstab queries, making temp
    tables, and the likes--yikes. Would such an interactive calendar even
    be possible in Access? And if so, any pointers on how to get started?

    Thanks
    Arnold
    Tags: None
    • Phil Stanton
      #2
      Re: Possibilities for Attendance-Tracking Calendar Form?

      About 1000 years ago I wrote an Access 1.1 (or perhaps Access2) program to
      clock staff in and out. Not used now for 15 years. Probably corrupt, but I
      could send it to you if it is any help

      Phil


      "Arnold" <ericarnold1@ya hoo.comwrote in message
      news:ffdd921c-d9af-4539-8dbc-440d4d664866@z3 8g2000hsc.googl egroups.com...
      Hello;
      I really want to make an attendance database similar to A.D. Tejpal's
      Query_CrosstabA ttendanceMarkin g,
      www.rogersaccesslibrary.com/OtherLibraries.asp,
      that, in addition to storing the date & time stamp in the calendar,
      allows users to input the following in each grid cell:
      >
      AttendanceType (P = Present (fills P by default every day), EX =
      excused, UX = unexcused, UK = unknown).
      AttendanceDetai ls (a text field for comments).
      A little In?Out togglebutton (In to be set as default for every new
      day, Out would reset the timestamp, storing the previous timestamp in
      a table to be used in time calculations of how long students are "Out"
      vs. "In").
      Plus the ability to modify former and future dates.
      Plus kitchen sink...
      >
      The only problem is that I am new to crosstab queries, making temp
      tables, and the likes--yikes. Would such an interactive calendar even
      be possible in Access? And if so, any pointers on how to get started?
      >
      Thanks
      Arnold

        Comment

        • Arnold
          #3
          Re: Possibilities for Attendance-Tracking Calendar Form?

          Thanks for replying Phil,

          Sounds great. Can later versions of Access open such past versions?
          Can you see my email address in this group?

          Thanks

            Comment

            • Arnold
              #4
              Re: Possibilities for Attendance-Tracking Calendar Form?

              Thanks Larry

                Comment

                Previous template Next
                Working...