Custom field inforamtion to be limitted to the summary line only.

M

Majid

Hello John
as per your advice, I an posting new thread.
Thank you for your respond, I agree the test field is very easy solution but
the problem is that originally I wanted to have the date field so that it is
easy for the team to click on the NA and use the calender and pick the actual
date, then because NA was appreaing on the entire field then I thought I
should use the flag field and then highlight the field to be more visual and
I am here now.
If you can help me please provide a micro that can take care of the date
field ( let say date 1) therefore, the value is apperread on the summary line
only and the rest of the field is stays blank ( has no NA).
I appreciate your help.
Regards,
Majid,
Assuming I understand what you want, I have a real simple solution. If
all you want is a "yes" or "no" indication at a summary line, use spare
text fields (e.g. Text1, Text2, etc.) instead of flag fields. Also, do
not use a custom field with a value list. There are only two possible
responses so a value list doesn't really offer that much convenience. It
is not that difficult to enter a "yes" or "no". Don't tell me your guys
are that lazy. And by using spare text fields instead of spare flag
fields, the only entry will be at the summary line.

If for some reason I have misunderstood what you want or my simple
solution is just not elegant enough there is a more complex solution. An
event based macro could be developed that will trigger on the entry at
the summary line and change the values for all task lines below it.

If you reply, start a new thread. The number of posts in this newsgroup
has exceeded my preferred setting for this newsgroup (i.e. 100 messages)
and I generally only check old messages if I see an indicator that I
have responded.

Hope this helps.
John
Project MVP
 
J

JackD

Simple to do this with a formula

iif([Summary],<whatever you want to do if it is a summary>, "")

Make sure that the customized field is set to use the formula for summaries.
 
J

John

JackD said:
Simple to do this with a formula

iif([Summary],<whatever you want to do if it is a summary>, "")

Make sure that the customized field is set to use the formula for summaries.

Jack,
Maybe I'm missing something, but I don't think it can be done with a
formula - at least not with a spare date field. Date fields require
either a valid date or "NA". A blank "doesn't compute".

Majid could use a spare date field to select a date from the calendar
and then use a formula in a spare text field that simply copies the date
in the summary line. However, the spare date field will still need to
show in the view in order to pick the date and that will leave "NA" on
the subtasks. The bottom line - he can't get there from here with a date
field.

John
 
J

JackD

Don't use a date field. Use a text field.
You can have dates or numbers or whatever in a text field. Project still
recognizes them as dates or numbers or whatever.


--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..
John said:
JackD said:
Simple to do this with a formula

iif([Summary],<whatever you want to do if it is a summary>, "")

Make sure that the customized field is set to use the formula for summaries.

Jack,
Maybe I'm missing something, but I don't think it can be done with a
formula - at least not with a spare date field. Date fields require
either a valid date or "NA". A blank "doesn't compute".

Majid could use a spare date field to select a date from the calendar
and then use a formula in a spare text field that simply copies the date
in the summary line. However, the spare date field will still need to
show in the view in order to pick the date and that will leave "NA" on
the subtasks. The bottom line - he can't get there from here with a date
field.

John
 
J

JackD

You can use the Time and Date Picker control on a user form.
Insert a user form. Open the Control Toolbox (should be open anyway, but if
it is not then open it)
Go to tools menu, choose "Additional Controls"
Find "Microsoft Date and Time Picker Control X.0" and check it. Then drag it
to your form.
Set the events for it so that it returns a value when it changes:

Private Sub DTPicker1_Change()
MsgBox DTPicker1.Value
End Sub

Now your macro only needs to show the user form.
 
J

John

JackD said:
Don't use a date field. Use a text field.
You can have dates or numbers or whatever in a text field. Project still
recognizes them as dates or numbers or whatever.


Jack,
Yeah that's what I suggested before. However, I think Majid wanted the
convenience of a calendar drop down that is only available with a date
field so the users could select a date rather than type one in.

By the way, do you know of any way to pop up a calendar selection in VBA
so it emulates what you get in a date field?

John
 
J

John

JackD said:
You can use the Time and Date Picker control on a user form.
Insert a user form. Open the Control Toolbox (should be open anyway, but if
it is not then open it)
Go to tools menu, choose "Additional Controls"
Find "Microsoft Date and Time Picker Control X.0" and check it. Then drag it
to your form.
Set the events for it so that it returns a value when it changes:

Private Sub DTPicker1_Change()
MsgBox DTPicker1.Value
End Sub

Now your macro only needs to show the user form.


Jack,
Interesting. Perhaps I can use that approach some time, and, maybe it
will help Majid to get where he want to go.

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top