Trying to doctor a template

[nick1408]

I hate being new to Access!

Anyway, I have downloaded the Task Management template as it is very close to what I want but I do need to alter it a bit. Anyway, I managed to add some tabs to the Task Detail form and that's where I got stuck.

I am after a few things:

1. A pic chart on the Task Details showing the % Completed from Tasks
2. Can I colour code cells so if the task is behind schedule (% Completed is less than Elapsed Time) - preferably in the % Completed cell
3. On Task Details on the Project Run Sheet tab I plan on having 25 steps to complete the task. Ideally, I would like to have these show one at a time and require validation before continuing. I was thinking a list with checkboxes would be suitable but since I am asking the hard questions I may as well through this in as well
4. On the Overview tab will be my milestones. These are linked to the Project Run Sheet. How can I link say Task 5 to Milestone 1 for example.
5. Once all of this is done I plan on showing both the current milestone and next task due on the Tasks form (in the last two columns). As I haven't looked at this yet how do I go about linking them to the right columns?

I'm pretty sure that would be ideal for me. I've attached the database in case anyone wants a look - https://www.dropbox.com/s/rtcbq3uljggnl54/Task Db.accdb?dl=0

Thanks for the help!

 

[Micron]

I chose to respond in block caps so that I could keep an answer with the question but make it stand out. Hope that's OK.

I am after a few things:
A pic chart on the Task Details showing the % Completed from Tasks. YOU CAN USE AN IMAGE FRAME, BUT IT WOULD BE MORE WORK THAN PAYBACK IMHO. CONSIDER LAYING A TEXTBOX (NO BORDER, BLUE) OVER ANOTHER WHOSE LENGTH IS APPROPRIATE FOR YOUR FORM AND REPRESENTS 100%. YOU ALTER THE WIDTH OF THE BLUE ONE ACCORDING TO THE % VALUE

1. Can I colour code cells so if the task is behind schedule (% Completed is less than Elapsed Time) - preferably in the % Completed cell ACCESS DOESN'T HAVE CELLS. YOU WANT TO CONDITIONALLY FORMAT THE CONTROL ACCORDING TO YOUR % VALUES.
2. On Task Details on the Project Run Sheet tab I plan on having 25 steps to complete the task. Ideally, I would like to have these show one at a time and require validation before continuing. I was thinking a list with checkboxes would be suitable but since I am asking the hard questions I may as well through this in as well. THESE ARE FORMS? I DON'T SEE THEM. THEY ARE TABBED FORMS, BUT NOT TABS, IMO. BASED ON LIMITED INFO, I DON'T LIKE THE SOUND OF NOT BEING ABLE TO SEE THE REST OF THE STEPS AT THE SAME TIME.
3. On the Overview tab will be my milestones. These are linked to the Project Run Sheet. How can I link say Task 5 to Milestone 1 for example. AS MENTIONED, DON'T SEE OVERVIEW FORM.
4. Once all of this is done I plan on showing both the current milestone and next task due on the Tasks form (in the last two columns). As I haven't looked at this yet how do I go about linking them to the right columns?AS MENTIONED, NOT RESTRICTING THE VIEW TO ONLY THE NEXT TASK WOULD HELP HERE. TABLE NORMALIZATION IS OF UTMOST IMPORTANCE, THEN BEING ABLE TO GATHER THE DETAILS VIA QUERIES COMES AFTER. IF YOU CAN BUILD A QUERY TO ASSEMBLE INFORMATION YOU NEED, YOU CAN SHOW IT ON A FORM.

I'm pretty sure that would be ideal for me. I've attached the database in case anyone wants a look - https://www.dropbox.com/s/rtcbq3uljggnl54/Task Db.accdb?dl=0

Thanks for the help!

Don't take this as condescending criticism, rather it is meant to help. I suspect you have not researched much into how to create a good db as you not only have spaces in all your object names, some of them even have the same name. Also, your form controls are named the same as your fields (Access does this when you use a wizard, but it's not good). Not only is "% Complete" a bad name for a field, it is a calculation and should not be stored in a table. I suggest you back up and increase your knowledge on db design before you do things now that you'll regret later (you already have, IMHO). If you want me to post some links or suggestions on what to look for, let me know.

 

[nick1408]

I have worked out how to add a graph but am having trouble getting it to show the info correctly. What I am doing is in the video below:

https://www.youtube.com/watch?v=rnt-wwPLdW4

What I am after is something like this:

http://blog.kurtosys.com/wp-content/uploads/2013/06/Flat-pie-chart.jpg

File is located here - https://www.dropbox.com/s/rtcbq3uljggnl54/Task Db.accdb?dl=0

What am I doing wrong though? I can't work it out.

 

[Micron]

You've incorporated a feature in your Task table that now prevents me from helping you due my older version (maybe Multivalue field?). Who knows, it could be one of your issues. Serious designers will tell you to avoid those like the plague.
Sorry.

 

[nick1408]

You've incorporated a feature in your Task table that now prevents me from helping you due my older version (maybe Multivalue field?). Who knows, it could be one of your issues. Serious designers will tell you to avoid those like the plague.
Sorry.

I guess that's the issue with using one of the MS Access templates available from within the program itself. I've been using this with Access 2013 so far.