Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - CrossTabDemo_2K.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)


 Post Reply Post Reply
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: CrossTabDemo_2K.mdb
    Posted: 09 Jul 2008 at 10:58pm
General -
        This database demonstrates data entry and report generation for an 
attendance register in spreadsheet style - featuring staggered dates (i.e. working 
days are restricted to two nominated weekdays)

Data Entry -
        In order to retain normal structure of the table storing basic data (i.e. 
student_ID, date and Yes/No field for attendance), at the same time presenting 
spreadsheet style interface where attendance checkboxes are displayed in a row 
across each student name, the checkbox controls on the subform are bound to an 
interim table. Values entered get pushed to the corresponding checkboxes (for 
particular student_ID and date)in the main table.
        Before commencing entries for a new month, the user has the option to set the 
nominated weekdays.

Report Generation -
        The report shows attendance markings arranged horizontally against each 
student. Headings for WeekdayNames & Dates for each attendance day are also 
        For generating the reports, temporary table is populated on the fly , using 
crosstab query based upon data filtered as per start and end YearMonths selected 
by user.

Version - Access 2000
       References - 
            Visual Basic For Applications
            Microsoft Access 9.0 Object Library
            OLE Automation
            ADO 2.6
Download Access 2000 (ADO): uploads/37/

Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.