Entering records by using calendar

[wnicole]

I have a database where we do scheduling. I would like to be able to choose a duration of dates and it create records for each of those days.
I don't mind going to each one and entering data...but having something that may ask if I like to duplicate data for each records (different days of course) would be great.


Is this complicated?

[Dal Jeanis]

Pretty basic, actually.

You'll use :
A form, which allows the user to choose the starting and ending date.
Some fields on that form for any information that is to be repeated.
A button on that form that says "Create Records"

Behind that button, in the Click Event, you'll have VBA code that does the following:
1) validate the fields on the form, especially the beginning and ending dates.
2) Exit with an error message if anything is critically missing or bad.
3) Loop through from the first date to the last date, and for each date, add a record with the entered information.

The loop could either be doing an INSERT to the table with DoCmd.RunSQL, or it could be doing a combination Recordset.ADDNEW and Recordset.UPDATE. There's sample code for either of those all over the internet.

[wnicole]

Can you tell me what the title of the code would be I can search the net?

[Dal Jeanis]

Here's a thread that has an example in it
https://www.accessforums.net/queries...nge-36173.html

The thread is not all relevant to your question. Just look at the code in post #6 in the routine called LoadMonthDates. For your requirements, you would NOT use the part that executes a DELETE against the same table.