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

Thanks
Renee

Re: Combining Resource and Task Tables by Rod

Rod
Thu Feb 17 00:17:26 CST 2005

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.

--

Rod Gill
Project MVP


"Renee Voice" <Renee Voice@discussions.microsoft.com> wrote in message
news:90607963-A631-4CFA-915E-307152D65722@microsoft.com...
> Is there any way of inserting a text field from the resource table into
> the
> task table?
>
> Thanks
> Renee



Re: Combining Resource and Task Tables by Jan

Jan
Thu Feb 17 02:02:15 CST 2005

Hi Renee,

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

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620
"Renee Voice" <Renee Voice@discussions.microsoft.com> schreef in bericht
news:90607963-A631-4CFA-915E-307152D65722@microsoft.com...
> Is there any way of inserting a text field from the resource table into
the
> task table?
>
> Thanks
> Renee



RE: Combining Resource and Task Tables by JulieS

JulieS
Thu Feb 17 08:05:05 CST 2005

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" wrote:

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

RE: Combining Resource and Task Tables by Renee

Renee
Thu Feb 17 20:03:02 CST 2005

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

"JulieS" wrote:

> 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" wrote:
>
> > Is there any way of inserting a text field from the resource table into the
> > task table?
> >
> > Thanks
> > Renee

Re: Combining Resource and Task Tables by Jan

Jan
Fri Feb 18 02:25:53 CST 2005

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
"Renee Voice" <Renee Voice@discussions.microsoft.com> schreef in bericht
news:A4B0F2EF-59F4-4ADA-8F94-ABC7AE6C3445@microsoft.com...
> 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
>
> "JulieS" wrote:
>
> > 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" wrote:
> >
> > > Is there any way of inserting a text field from the resource table
into the
> > > task table?
> > >
> > > Thanks
> > > Renee