Help creating a custom filter

[sdc]

I am new to custom filters and am hoping that someone can help me with the
proper semantics for creating two different filters to help me learn. This is
for a large “evolving†project plan that contains a number of inter-related
sub-projects with many task links . Here is the (hopefully) correct logic for
the first filter that I am trying to create:
1) Desired Filter: List all project tasks for sub -“project ABC†AND all
linked predecessor and successor tasks to sub-“project ABCâ€

Here is the limited semantics I have so far: [name contains “project ABCâ€
AND predecessor ??? OR successor ????

2) Desired Filter: List all linked project tasks where the predecessor
finish date is later than the successor start date.

I know that this is “poor†project planning, but we are working with
multiple groups with linked projects and we need to quickly show date
conflicts so we can resolve these issues. We want to be able to ‘red flag’
these items quickly and hopefully this type of “report†could help. Can one
use a filter to compare values of linked tasks?


If anyone could provide assistance or point me in the right direction this
would be greatly appreciated.
Thank you!
sdc

 

[Jan De Messemaeker]

Hi,

Filter definitions only refer to fields in te task itself or to Project
Fields.
You can use a VBA procedure to calculate the true or false of your
conditions, enter this value for each task into a flag firld, and filter on
the flag field.
HTH


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[sdc]

Hi,
Thank you so much for your reply. I need to learn VBA - do you have a
recommended online training course or book ?

Thank you!
sdc

Hi,

Filter definitions only refer to fields in te task itself or to Project
Fields.
You can use a VBA procedure to calculate the true or false of your
conditions, enter this value for each task into a flag firld, and filter on
the flag field.
HTH


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

I am new to custom filters and am hoping that someone can help me with the
proper semantics for creating two different filters to help me learn. This
is
for a large "evolving" project plan that contains a number of
inter-related
sub-projects with many task links . Here is the (hopefully) correct logic
for
the first filter that I am trying to create:
1) Desired Filter: List all project tasks for sub -"project ABC" AND all
linked predecessor and successor tasks to sub-"project ABC"

Here is the limited semantics I have so far: [name contains "project
ABC"
AND predecessor ??? OR successor ????

2) Desired Filter: List all linked project tasks where the predecessor
finish date is later than the successor start date.

I know that this is "poor" project planning, but we are working with
multiple groups with linked projects and we need to quickly show date
conflicts so we can resolve these issues. We want to be able to 'red flag'
these items quickly and hopefully this type of "report" could help. Can
one
use a filter to compare values of linked tasks?


If anyone could provide assistance or point me in the right direction this
would be greatly appreciated.
Thank you!
sdc

 

[Jan De Messemaeker]

Hi,

There's to my knowledge only one book on VBA for Project- and fortunately
it's very good.
It's by fellow MVP Rod Gill:

VBA Programming for Microsoft Office Project
ISBN 0-9759828-7-7

Good Luck!

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Hi,
Thank you so much for your reply. I need to learn VBA - do you have a
recommended online training course or book ?

Thank you!
sdc

Hi,

Filter definitions only refer to fields in te task itself or to Project
Fields.
You can use a VBA procedure to calculate the true or false of your
conditions, enter this value for each task into a flag firld, and filter
on
the flag field.
HTH


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

I am new to custom filters and am hoping that someone can help me with
the
proper semantics for creating two different filters to help me learn.
This
is
for a large "evolving" project plan that contains a number of
inter-related
sub-projects with many task links . Here is the (hopefully) correct
logic
for
the first filter that I am trying to create:
1) Desired Filter: List all project tasks for sub -"project ABC" AND
all
linked predecessor and successor tasks to sub-"project ABC"

Here is the limited semantics I have so far: [name contains "project
ABC"
AND predecessor ??? OR successor ????

2) Desired Filter: List all linked project tasks where the predecessor
finish date is later than the successor start date.

I know that this is "poor" project planning, but we are working with
multiple groups with linked projects and we need to quickly show date
conflicts so we can resolve these issues. We want to be able to 'red
flag'
these items quickly and hopefully this type of "report" could help.
Can
one
use a filter to compare values of linked tasks?


If anyone could provide assistance or point me in the right direction
this
would be greatly appreciated.
Thank you!
sdc

 

[Dale Howard [MVP]]

sdc --

You can find the book that Jan recommends at:

http://www.projectserverbooks.com

It is published by our company, msProjectExperts. It is an awesome book, if
I do say so myself!

Hi,

There's to my knowledge only one book on VBA for Project- and fortunately
it's very good.
It's by fellow MVP Rod Gill:

VBA Programming for Microsoft Office Project
ISBN 0-9759828-7-7

Good Luck!

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Hi,
Thank you so much for your reply. I need to learn VBA - do you have a
recommended online training course or book ?

Thank you!
sdc

Hi,

Filter definitions only refer to fields in te task itself or to Project
Fields.
You can use a VBA procedure to calculate the true or false of your
conditions, enter this value for each task into a flag firld, and filter
on
the flag field.
HTH


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
I am new to custom filters and am hoping that someone can help me with
the
proper semantics for creating two different filters to help me learn.
This
is
for a large "evolving" project plan that contains a number of
inter-related
sub-projects with many task links . Here is the (hopefully) correct
logic
for
the first filter that I am trying to create:
1) Desired Filter: List all project tasks for sub -"project ABC" AND
all
linked predecessor and successor tasks to sub-"project ABC"

Here is the limited semantics I have so far: [name contains "project
ABC"
AND predecessor ??? OR successor ????

2) Desired Filter: List all linked project tasks where the
predecessor
finish date is later than the successor start date.

I know that this is "poor" project planning, but we are working with
multiple groups with linked projects and we need to quickly show date
conflicts so we can resolve these issues. We want to be able to 'red
flag'
these items quickly and hopefully this type of "report" could help.
Can
one
use a filter to compare values of linked tasks?


If anyone could provide assistance or point me in the right direction
this
would be greatly appreciated.
Thank you!
sdc

 

[Jack Dahlgren]

No you can't

-Jack

Are you sure that you need to do what you say you need to do?
Are you sure that you need to learn VBA?

Usually, in this group people are given advice about how to do something,
whatever they are asking for, even if no one thinks there is a really good
reason to do it.

OK, VBA's good to know, but really you can do everything that is important
and necessary with MSP without VBA.

Trevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING
www.perfectproject.com.au

Hi,
Thank you so much for your reply. I need to learn VBA - do you have a
recommended online training course or book ?

Thank you!
sdc

Hi,

Filter definitions only refer to fields in te task itself or to Project
Fields.
You can use a VBA procedure to calculate the true or false of your
conditions, enter this value for each task into a flag firld, and filter
on
the flag field.
HTH


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
I am new to custom filters and am hoping that someone can help me with
the
proper semantics for creating two different filters to help me learn.
This
is
for a large "evolving" project plan that contains a number of
inter-related
sub-projects with many task links . Here is the (hopefully) correct
logic
for
the first filter that I am trying to create:
1) Desired Filter: List all project tasks for sub -"project ABC" AND
all
linked predecessor and successor tasks to sub-"project ABC"

Here is the limited semantics I have so far: [name contains "project
ABC"
AND predecessor ??? OR successor ????

2) Desired Filter: List all linked project tasks where the predecessor
finish date is later than the successor start date.

I know that this is "poor" project planning, but we are working with
multiple groups with linked projects and we need to quickly show date
conflicts so we can resolve these issues. We want to be able to 'red
flag'
these items quickly and hopefully this type of "report" could help.
Can
one
use a filter to compare values of linked tasks?


If anyone could provide assistance or point me in the right direction
this
would be greatly appreciated.
Thank you!
sdc