custom input form to modify existing tasks

[kcrad]

Can I design a form to modify existing tasks? For instance, if I work on
several different tasks in a day but do not complete any of them I would like
to be able to open a form, pull down a list of tasks that are already in
Project, and input the time that I worked on each task. Then Project should
be able to automatically split the task (if needed) and update the rest of
the charts.

 

[Jan De Messemaeker]

Hi,

Why design a form? You can perfectly do that in Resource Usage View

 

[kcrad]

OK, I tried that and it works pretty well. It brings up an additional
problem though - some of my subtasks have identical names under different
taskbars. For instance, taskbars "Create A" and "Create B" have identical
processes. When I look at the assigned tasks in the resource view, there is
no distinction between which taskbar the tasks came from. I need that
information to be included or else the resource page is meaningless to me.

 

[JulieS]

Hi kcrad,

Try adding the Task Summary Name field to the Resource Usage view (left
side) and see if that helps.

I hope this helps. Let us know how you get along.

Julie

 

[Jan De Messemaeker]

Hi,

Try this macro:

Sub SumNameIn RU
dim Job as task
dim Whodunit as assignment

for each job in activeproject.tasks
if not job is nothing then
if not job.summary then
if job.outlinelevel>1 then
for each whodunit on job.assignments
whodunit.text1=job.outlineparent.name
next whodunit
end if
end if
end if

End Sub

Paste the code in a module in the Visual Basic Editor (Alt+F11), run the
Macro and in the Resource Usage View insert the column Text1.

HTH

 

[Jan De Messemaeker]

Oh Boy (or rather, Oh Girl)! Shame! I did not know there was a Task Summary
Name field!

 

[JulieS]

Hi Jan,

I stumbled upon it a while ago and have found it very useful for what kcrad
was seeking -- but it was purely accidental ;-)

Julie

 

[kcrad]

Thanks Julie. This does work, but it only shows one level above my tasks.
Is there a way to show higher levels as well? That would be very helpful.

Jan - I couldn't get the macro to work. VB said that there is a syntax
error. I'm not familiar enough with the program to troubleshoot.

Thanks,

Kcrad

Hi Jan,

I stumbled upon it a while ago and have found it very useful for what kcrad
was seeking -- but it was purely accidental ;-)

Julie

 

[Jan De Messemaeker]

Hi,

Indeed. The final end if statement should be followed by a Next statement
(on a line of its own).
Sorry.
As for multiiple levels you would need a far more complex macro.
Greetings,

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm

Thanks Julie. This does work, but it only shows one level above my tasks.
Is there a way to show higher levels as well? That would be very helpful.

Jan - I couldn't get the macro to work. VB said that there is a syntax
error. I'm not familiar enough with the program to troubleshoot.

Thanks,

Kcrad

 

[JulieS]

Hi Kcrad,

Another option is two macros written by fellow MVP, Jack Dahlgren:
Summary Name - which stores the full path of the parent tasks in a task
field
and
Copy task Fields - which copies data from a task custom field to an
assignment custom field.

Both macros can be found at:
http://masamiki.com/project/macros.htm

Note: you will need to edit the Copy task field macro to pick up the Text12
field from the task side.

I am not a VBA guru (like Jack and Jan) so they may be able to advise better
on how to combine the two macros.

I hope this helps. Let us know how you get along.

Julie

Thanks Julie. This does work, but it only shows one level above my tasks.
Is there a way to show higher levels as well? That would be very helpful.

Jan - I couldn't get the macro to work. VB said that there is a syntax
error. I'm not familiar enough with the program to troubleshoot.

Thanks,

Kcrad

 

[kcrad]

Thanks for all of the help. I've stumbled on exactly what I was looking for
in another part of the software. Under the Resource Usage View, I can use
the group tool and use the "keep outline structure" option.