How do you force task level recals automatically?

E

Ed

Hi all,

I previously posted a question about generating a "New
Notes" indicator.

My solution is as follows:
Create a custom number field with the formula:
instr([Notes],format(now()-0,"mm/dd/yy")&")")+instr
([Notes],format(now()-1,"mm/dd/yy")&")")+instr
([Notes],format(now()-2,"mm/dd/yy")&")")+instr
([Notes],format(now()-4,"mm/dd/yy")&")")+instr
([Notes],format(now()-5,"mm/dd/yy")&")"
)
Set a graphical indicator to display if result > 0.

This will generate a New Note indicator for notes created
within the past 5 days.

BUT IT DOESN'T WORK!
Tasks fields only get recalculated when you touch that
task or if you hit F9!

HOW can I FORCE a recalc of ALL TASKS whenever a plan is
opened?

Can anyone help me out here?

Thanks!

Ed
 
K

Kelvin Kirby

Hi Ed,

Try creating an Auto_Open macro that forces a Recalc when a project is
opened.

I haven't tried it in the sceanrio you mentioned but this would be my next
step.

Regards

Kelvin Kirby
Technology Associates International
 
Top