Hello everyone. I need help trying to get my head around this. I have a table which we use to track our employee's appointments. We use a form to fill in pertinent information into this table. Once filled in another form designed like a calender pops up listing each of these appointments. Our issue is this. We have to fill out this form for each day the employee is gone or they will not show up on the calender. For one day appointments this is no big deal but when the employee takes numerous days off we have to fill out a form for each day.
We would like to have a way to use this form and only have to fill in the start date and end dates and have Access copy and insert a record for each day between. Is this possible? Thanks
We would like to have a way to use this form and only have to fill in the start date and end dates and have Access copy and insert a record for each day between. Is this possible? Thanks
