[AccessD] Creating Daily Records

Chester,

    In such situations, it is often convenient to display a grid of virtual new records for he month in question. Such an arrangement has the advantage that while the user can see at a glance all the available data entry slots, no redundant record gets actually inserted in the source table until some data is positively entered into it.  

    My sample db named Form_VirtualRecordsMatrix demonstrates the approach outlined above. It is in access 2000 file format and is available at Rogers Access Library. Link - 
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45
 
    Brief description is placed below.

Best wishes,
A.D. Tejpal
------------

Form_VirtualRecordsMatrix (Sample Db)
Brief Description
===============================
    This sample db demonstrates generation and display of a matrix of virtual new records. This arrangement has the advantage that while the user can see at a glance all the available data entry slots, no redundant record actually gets inserted in the source table until some data is actually entered in it.  

    For example, task planner for December would show 31 virtual records, one for each day of the month. If the user makes entries only for 5th and 20th December, only these two records will actually get inserted in the table, while records pertaining to all the 31 days continue to get displayed.

    Three styles have been demonstrated in this sample db:
    (a) Task planner as per each day of the given month.
    (b) Task planner as per half hourly time slots on the given day.
    (c) Bike sales: For each batch of bikes received, a matrix having number of virtual records matching the batch size (number of bikes received in the given batch) is displayed. As and when a bike gets sold, ticking the check box inserts the record in source table with automatic filling in of sale date as well as sale stamp fields.

Note:
    Styles (a) and (b) above use a modified version of calendar form originally developed by Allen Browne. Following features have been incorporated while implementing the adaptation:
    (a) Use of calendar form as a subform.
    (b) Mild highlighting (persistent) of today's date - This is in addition to strong highlighting of selected date.
    (c) Two way synchronization between calendar subform and task planner subform.

Version: Access 2000 file format. 
=======================================

  ----- Original Message ----- 
  From: Kaup, Chester 
  To: Access Developers discussion and problem solving 
  Sent: Tuesday, November 17, 2009 19:09
  Subject: [AccessD] Creating Daily Records


  I have a table that has one record on the first day of each month. I need to duplicate this record for each day of the month. I need help on how to do this. Thanks.

  Chester Kaup