MSP2k Task Form Customization

[Glenn Harrison]

I would like to customize the Task Form/Task Details Form as follows,
when the 'Predecessor & Successors' sub-form is displayed:

- for each Predecessor displayed (assume several listed), display the
Finish Date for the predecessor, and sort them (ascending) by Finish
Date
- for each Successor displayed (assume several listed), display the
Start Date for the Successor, and sort them (ascending) by Start Date

In the first dash item, I am attempting to easily determine the
predecessor (when there are several) that is "driving" the start date
of the task that I have selected, without having to manually trace
back through the schedule or interpret a graphical representation.

The second dash item is similar.

If there is a Visual Basic solution, pls. suggest one since I enjoy
playing in VBA.

Thank you.

- Glenn Harrison

 

[John]

Glenn,
Unfortunately the built-in forms are not fully editable as are views.
That is, the "Table" that defines the fields presented in the form's
columns is fixed.

Yes, there is always a VBA solution and possibly you could also
replicate the built-in forms with you own userforms. In my opinion the
VBA solution is more convenient. I would determine exactly what Project
data fields, or other information created with algorithms, is needed,
and export that information to an Excel Worksheet. There it can be
formatted exactly as desired and printed or e-mailed if desired. Since
you like playing with VBA this procedure would be a nice exercise.

Hope this helps.
John