Code to populate a calendar table with date specific information
I need to create a command button when clicked will take the calendar month enter in a textbox and populate a calendar table for me. This table is called CalendarDates and is used in some reports where a listing of all the days in the month are needed. The textbox will contain a date for the first day of that month (ie 03/01/2004 = March 01 2004).
The table is structured to have the fields:
Week's End date (03/06/2004) Last day of the week which the current record's date follows into
I don't have a clue how to do this. Can someone please help out?