How to Automatically Populate 30 fields

[Guest]

Hey, I have a datasheet with numerous fields pertaining to an employee's
timecard. Example's include date, time in, time out, etc. On my switchboard I
have a button that when clicked deletes all the records out of this datasheet.

My problem is that after the records are deleted I want 30 new records to
populate under the date column. I need 5 new records per day (Mon - Sat) for
a total of 30 new records. How do I go about doing this? I have included a
better example of my problem below.

DATASHEET

DATE TIME IN TIME OUT

Mon 8:00 5:00
Mon " "
Mon " "
Mon " "
Tues 8:00 5:00
Tues " "
Tues " "
Tues " "
Etc

AFTER I CLICK THE DELETE BUTTON I WANT MY DATASHEET TO LOOK LIKE THIS

DATE TIME IN TIME OUT

Mon
Mon
Mon
Mon
Tues
Tues
Tues
Tues
Etc

Thanks,

 

[Michel Walsh]

Hi,


Have a "default table" filled with the records, and, after you delete the
records in your working table, append the records from the default table to
the working table.


Hoping it may help,
Vanderghast, Access MVP