Print Page | Close Window


Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
Printed Date: 18 Mar 2018 at 9:45pm

Topic: CrossTabDemo_2K.mdb
Posted By: A.D. Tejpal
Subject: CrossTabDemo_2K.mdb
Date 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/ 


Email: -

Print Page | Close Window