I am hoping someone can help me. I am a complete novice, but have been trying to build a database to track productivity for my team. It uses the template for the Task Manager in Access and I have it working very well. I have created a switchboard and forms to enter in team members, and new tasks, edit existing tasks, and even have some reports created as well. The issue I am having is that many of these tasks are different recurring reports that must be run by team members, at different intervals, throughout the year (and beyond). I came across the excellent sample DB and explanation by Allen Browne and it is exactly what I need, but I am unsure how to incorporate it to work with the Task Manager.
Ideally, I would like to be to track the recurring events and have the future occurrence dates automatically populate the task manager so that team members just need to go in, see what tasks are due for the day, complete them or to go in and "complete" the existing occurrence and then have the DB automatically enter in the next occurrence.
Currently, I have a form that everything is entered in manually, and every occurrence would need to be figured out manually and then entered in manually. Some of the tasks are daily, weekly, month and some are quarterly etc. So, if done by hand, this would be become very time-consuming very quickly.
From what I see Mr. Browne's current db does not house the future occurrences in a table that I can just easily pull into the task manager. I feel like the solution here is right in front of me and not that complex, but fear I have been staring at all the code and tables and relationships so long that I have completed overwhelmed myself.
Can anyone help? I am a complete novice to VBA, so if suggesting code, please be gentle and patient with me.
Thank you in advance.
Debbieto