471,572 Members | 904 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,572 software developers and data experts.

Recurring Events and the Task Manager

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
1 Week Ago #1
1 4288
NeoPa
32,439 Expert Mod 16PB
Hi Debbie.

Welcome to Bytes.com.

I would help you if I could, but I'm afraid there is so much about your question that makes no sense to me. What Task Manager are you referring to? I only know of the Windows Task Manager - and if that's what you mean you've lost me.

Where does the Access work fit into your project?

From what I can understand it seems you may have taken on a project that is far beyond the basic level. Would you agree? Is this project right for you? Are you nearly there but just can't explain the situation very well?

Clearly you don't lack the will to put work into explaining the problem. Unfortunately, such abilities often take experience to develop such that someone reading it can find it meaningful.

I wish you good luck anyway.
1 Week Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Shabam | last post: by
6 posts views Thread by rodchar | last post: by
3 posts views Thread by Inbox.Mirror.Orbisoft | last post: by
reply views Thread by Inbox.Mirror.Orbisoft | last post: by
4 posts views Thread by e-Ricc | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by Vinnie | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.