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

>
Want a good read? Try The Summer of His Life (available on Amazon!)

CrossTabDemo_2K.mdb

 Post Reply Post Reply
Author
Message
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 
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
--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

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.