CrossTabDemo_2K.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
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): uploads/37/CrossTabDemo_2K.zip |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |