Form to automatically add new records with default values

[Help!]

I'm trying to create a form that will add 7 records to my hours table (1 for each day of a specified week; Startdate to Enddate) for each record of an employee query.



I tried using a continuous subform for each employee with default data for #of hours and type. The problem is the date. If have to click on the calendar and click the date for each of the seven days for each employee. (appoximately 560 times) Carpal Tunnel!

Is there any way to get the dates to programatically appear based on StartDate, Startdate + 1, StartDate + 2 and so on till the EndDate?


My other idea is to make an Append query for each employee and each date. Does anyone know if thats possible?

[June7]

Yes, can use VBA code to run APPEND action.

Is there any other data besides employeeID, date, hours, type entered for each record?

[Help!]

Yes that's it.

Also I've never gone near VBA Code.

[June7]

This about the 4th thread I reviewed today with requirement to programmatically create records.

Macros can run an Access action query object but looping structure with a macro is not easy. And for what you want, don't event think about it.

So you have a lot to learn. Need understanding of basic programming concepts, VBA language/syntax, SQL, opening and manipulating recordsets in VBA.

Another approach is to programmatically modify the DefaultValue property of a control. However, this requires that a record be initiated by entering some value into another field. New record initiation triggers the DefaultValue. So would still have to do data entry of 7 records for each employee.
http://access.mvps.org/access/forms/frm0012.htm
http://allenbrowne.com/ser-24.html

[Help!]

I do have programming experience with DOS and some SQL, but you put me on the right track and I thank you.