How to modify the lower pain to show successor tasks with % Complt?

Y

y7c4g2k5

MS Project Standard 2003 (stand alone operating mode) - trying to
overcome the issue of having all successors completed for an active
task (<100%) and yet project doesn't tell you this - there should be a
warning pop up stating that "Successors Completed - broken logic", -
anyway if by using the split pane and having the successors listed with
their percent complete field shown would help, I'm looking for VBA to
solve this or is their a custom field trick that will communicate the
same message? Thanking you in advance - JK
 
J

Jan De Messemaeker

Hi,

Before I start witing some VBA (it's not too difficult) I'd like to check
the question.
IMHO the logic is already broken whan there is ANY actual work on ANY of the
successors, you don't have to wait till ALL succesors are 100% finished.

That would give something like this:

For each Job in activeproject.tasks
if not job is nothing then
job.flag7=false
if not job.percentcomplete=100 then
For each Suc is job.successortasks
if suc.percentcomplete>0 then
job.flag7=true
exit for
end if
next suc
end if
end if
next job

A filter on flag7 would show what you need.
HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top