Prev: Missing File- Urgent
Next: Problem starting up Project 2000 - runtime error
From: Martin Wilkinson on 11 Oct 2005 10:50
You can Customise the text field Customize Fields/Custom Attributes/Value
List. You can populate this to create a drop-down pick list which contains
your base number plus the textual interpretation. Only the base number gets
put into the field.

Martin

"Bob Vardell" wrote:

> Thanks again, John! I will work on this in the next week. By the way is
> there a method for associating the two digit code in the text field with
> another text field that is a short description of the code definition? i.e.
> 01 would associate with a field that automatically populated with "Branch
> Conduit".
>
> "John" wrote:
>
> > In article <6088439F-9D5E-4A9D-A6AF-CFD9F9C8FF1F(a)microsoft.com>,
> > "Bob Vardell" <BobVardell(a)discussions.microsoft.com> wrote:
> >
> > > John,
> > >
> > > Thanks so much. What I really wanted to accomplish is to have the three
> > > fields of two codes each that are a drop down with explanation of each
> > > possible choice in each of the three fields. Is that possible? The intent
> > > here is to try and use this as not only a scheduling tool, but make it easier
> > > for managers to pick the right choices of digits when they set the project
> > > up. If we don't help them use the codes in the right method our AS/400
> > > reporting structure becomes less than accurate for reporting purposes.
> > > Additionally, we are working on a way to have a csv file from project import
> > > right into AS/400 for data entry of the project plan so we do not need
> > > overhead to type it in again.
> > >
> > > Thanks!
> > > Bob V.
> >
> >
> > Bob,
> > You're welcome.
> >
> > Having a drop down with choices is the next step in using spare fields.
> > Let's assume you are using Text1, Text2 and Text3 to store the three
> > part of the code. Go to Tools/Customize/Fields and set each text field
> > up with a Value List. More details on customizing fields is available in
> > the Help file.
> >
> > With regard to creating csv files for import into AS/400. I'm not
> > familiar with AS/400 but as long as it can read csv, it shouldn't be to
> > difficult to automate the transfer. As it turns out I am working with a
> > client right now to create two csv data files for import by another
> > application. The user will have two options. One option is to export the
> > required Project data to Excel where it can then be viewed, massaged if
> > necessary, and finally saved as a csv. The second option is to create
> > the csv file directly from Project. All this is being done with a VBA
> > macro. However, if the csv format can be set up with a customized view
> > in Project, (i.e. get the required Project fields in the right
> > sequence), It is even easier. Then all you will need is to do a Save As
> > and chose csv as the format. I've never tried that approach so I don't
> > know if there are any issues to watch out for but it might work for you
> > if you do not have VBA experience.
> >
> > Hope this helps.
> > John
> > Project MVP
> >
From: John on 11 Oct 2005 12:31
In article <5FD15CAC-8A69-4DEE-AEFC-8DFB88FBCA58(a)microsoft.com>,
"Bob Vardell" <BobVardell(a)discussions.microsoft.com> wrote:

> Thanks again, John! I will work on this in the next week. By the way is
> there a method for associating the two digit code in the text field with
> another text field that is a short description of the code definition? i.e.
> 01 would associate with a field that automatically populated with "Branch
> Conduit".


Bob,
You're welcome. If you read the help file on customized fields or even
tried it just to see what it was like, you would have you answer (i.e.
just like Martin explained in his response).

John
Project MVP
From: Bob Vardell on 14 Oct 2005 10:21
John & All,

I can get this to work in the project that is open, however how do I change
it for a master project and all users that start new projects?

Thanks,
Bob V.

"John" wrote:

> In article <5FD15CAC-8A69-4DEE-AEFC-8DFB88FBCA58(a)microsoft.com>,
> "Bob Vardell" <BobVardell(a)discussions.microsoft.com> wrote:
>
> > Thanks again, John! I will work on this in the next week. By the way is
> > there a method for associating the two digit code in the text field with
> > another text field that is a short description of the code definition? i.e.
> > 01 would associate with a field that automatically populated with "Branch
> > Conduit".
>
>
> Bob,
> You're welcome. If you read the help file on customized fields or even
> tried it just to see what it was like, you would have you answer (i.e.
> just like Martin explained in his response).
>
> John
> Project MVP
>
From: John on 14 Oct 2005 12:19
In article <D37280C6-6958-4424-8134-E4E2BF0ABFD0(a)microsoft.com>,
"Bob Vardell" <BobVardell(a)discussions.microsoft.com> wrote:

> John & All,
>
> I can get this to work in the project that is open, however how do I change
> it for a master project and all users that start new projects?
>
> Thanks,
> Bob V.


Bob,
I almost didn't see your latest post (it was way at the bottom of my
newsgroup message list - I set a limit of 200 messages). If you have
further questions on this subject you might want to repost with a new
message.

I just ran a quick test on my test file which is a consolidated master.
Apparently in a master file a value list (like formulas) is only active
in the file where it is created. Therefore you will need to set up the
value list in each subproject in addition to the master. What I am not
sure about, but it's something you can try, is whether a template file
will preserve a value list. If so, then you can set up a template and
use that for all new project.

Hope this helps.
John
Project MVP
First  |  Prev  | 
Pages: 1 2
Prev: Missing File- Urgent
Next: Problem starting up Project 2000 - runtime error