Add records with empty dates to calendar
Posted on 2004-10-25
The problem is to insert “empty dates” in a table containing information about The Boss’s calendar.
The table is called CleanCalendar. It has the following fields:
The Boss likes to have a space on his hard copy calendar for every day for the next six months, whether a given day has an appointment or not.
The appointments are being pulled in from his Outlook Calendar but Outlook only creates a record if there’s an appointment on that day, so I need to fill in the “empty dates.”
If I were writing pseudo code for this it would look like:
For MyDay = Today to Today’s Month Plus 6
Find Record where StartDate = MyDay
If Not Found, Insert Record Where StartDate = MyDay
Can I do this somehow in Access?