Print Page | Close Window

CrossTabDemo_2K.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=124
Printed Date: 17 Dec 2017 at 2:38pm


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 
displayed.
        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):  http://www.rogersaccesslibrary.com/forum/uploads/37/CrossTabDemo_2K.zip - uploads/37/CrossTabDemo_2K.zip 


-------------
--

Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com



Print Page | Close Window