Dependency Violation

[RichardJ]

Has anybody got any bright ideas how I can show a dependency violation
between linked tasks in MSP2003?

 

[Jim Aksel]

Try using some VBA. You could evalute the conditions (such as a successor
task starting prior to a predecessor being 100% complete, starting prior to a
Start No Earlier Than constraint, deadline violated...) and write "Yes" or
"No" to a flag field. You could also return a number to a number field and
then change the formating to give you a nice colored indicator depending on
the violation.

If you go the VBA route, experience tells me to exclude summary tasks,
external tasks, completed tasks, and blank lines from the analysis.

Another way to do this is with deadlines (it depends on your constraint).
MSP will automatically place a red diamond in the indicators column should a
deadline date be passed.
--
If this post was helpful, please consider rating it.

Jim

Check out my new blog for more information:
http://www.msprojectblog.com

 

[RichardJ]

Jim,
That's what I thought but my skills with VBA are limited (somemay say
non-existent)!

Can you provide an example of code that I could start with?

 

[Jim Aksel]

A very rough skeleton is shown below. I have plenty of ideas, etc. on how to
help you. Indeed much of what you need I already have. Unfortunately this
would not be "freeware" if you catch my drift. I wonder what might happen if
you clicked on the link below and dug around a little bit. Certainly a phone
call for a few minutes is available. Keep in mind any time zone or location
differences.

Here is the roughest of code:

Private Sub LogicCheck(ByRef mProject)

'Note: The parameters passed above are based on some other code. ZGut check
tells me there are more parameters you need to pass, like the status date,
etc.

Dim pTask As Task

For Each pTask In mProject.Tasks

'Do not update blank lines
If Not pTask Is Nothing Then

'Summary tasks can never require update
If pTask.Summary = True Then
pTask.Flag10 = False
End If

'Do not update external tasks or summary tasks
If (pTask.Summary = False) And (pTask.ExternalTask = False) Then
'default is no update required
pTask.Flag10 = False



'All your tests would go here. Use your imagination


End If 'summary/external task check
End If 'blank line check

Next pTask 'Next Task

End Sub


--
If this post was helpful, please consider rating it.

Jim

Check out my new blog for more information:
http://www.msprojectblog.com

 

[RichardJ]

Jim,
Thanks for the pointers. It's true that you learn something new everyday
and this is certainly a steep learning curve for me!

 

[Mike Glen]

Hi Jim,

Next time, try posting on the microsoft.public.project.developer newsgroup.
Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and
other useful Project information can be seen at this web address:
http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

 

[Jim Aksel]

Yes, my bad.