Combining Resource and Task Tables

[Renee Voice]

Is there any way of inserting a text field from the resource table into the
task table?

Thanks
Renee

 

[Rod Gill]

No.

The only resource fields you can see in a task or Gantt chart are: Resource
Name, Initials and Group. You can copy information across using VBA.

 

[Jan De Messemaeker]

Hi Renee,

Not directly.
For a more indepth explanation see
http://www.mvps.org/project/faqs.htm
faq 37. Custom fields in tables

HTH

 

[JulieS]

Hi Renee,

I addition to Rod and Jan's comments, there *may* be an additional field
(depending upon your language version of Project) that you can use to enter
text data in on the Resource table and have it show in the Task table. On
the resource sheet, insert the field [Phonetics]. The field is apparently
only used in the Japanese version of Project to store phonetic information,
however the field is available for entry (at least in the English version.)

Then in the Task table insert the field [Resource Phonetics]. The field
will show information entered from the Resource table for resources assigned
to tasks.

I have used the field (with a re-named title) to carry text information from
resources back to tasks.

Hope this helps. Let us know how you get along.

Julie

 

[Renee Voice]

Hi Everyone

Thanks for all your suggesstions.

The view is the Task Usage view and they want to insert a text field they
have created in the resource sheet. It is a list of codes that they want to
insert next to the resources listed in the task usage view. I have tried
some code and managed to insert the resource names next to the task as an
extra column but can't get this text field to appear. A real challenge.

Thanks
Renee

Hi Renee,

I addition to Rod and Jan's comments, there *may* be an additional field
(depending upon your language version of Project) that you can use to enter
text data in on the Resource table and have it show in the Task table. On
the resource sheet, insert the field [Phonetics]. The field is apparently
only used in the Japanese version of Project to store phonetic information,
however the field is available for entry (at least in the English version.)

Then in the Task table insert the field [Resource Phonetics]. The field
will show information entered from the Resource table for resources assigned
to tasks.

I have used the field (with a re-named title) to carry text information from
resources back to tasks.

Hope this helps. Let us know how you get along.

Julie

Is there any way of inserting a text field from the resource table into the
task table?

Thanks
Renee

 

[Jan De Messemaeker]

Hi Renee,

The FAQ I gave the address of explains it all, and the fact that you re
still "trying" means apparently you did not read the FAQ.
There is no such thing a a resource visible in the task usage view.
What you see in the Tak usage view (and in the Resource Usage View!) are
ASSIGNMENTS.
Assignments have custom fields of their own.
If you want to show data from a resource custom field in the asignment
custom fields you have to copy the data, either manually or through a VBA
macro.
Manually, you can insert the field in the resource usage view and copy it
from the resource to the assignment lines (f.i. by Ctrl+D). It will then be
visible in the Resource Usage view a well.
There is an example of VBA code in the FAQ.
HTH


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620

Hi Everyone

Thanks for all your suggesstions.

The view is the Task Usage view and they want to insert a text field they
have created in the resource sheet. It is a list of codes that they want to
insert next to the resources listed in the task usage view. I have tried
some code and managed to insert the resource names next to the task as an
extra column but can't get this text field to appear. A real challenge.

Thanks
Renee

Hi Renee,

I addition to Rod and Jan's comments, there *may* be an additional field
(depending upon your language version of Project) that you can use to enter
text data in on the Resource table and have it show in the Task table. On
the resource sheet, insert the field [Phonetics]. The field is apparently
only used in the Japanese version of Project to store phonetic information,
however the field is available for entry (at least in the English version.)

Then in the Task table insert the field [Resource Phonetics]. The field
will show information entered from the Resource table for resources assigned
to tasks.

I have used the field (with a re-named title) to carry text information from
resources back to tasks.

Hope this helps. Let us know how you get along.

Julie

Is there any way of inserting a text field from the resource table into the
task table?

Thanks
Renee