how to change the filed number1

B

Bruno

Hi there,

I want to change the number1 field for each tasks, if one other filed of a
task changes.

I tried to access a "change" event of a or all tasks - but sofar, I was
unsucessful. Is there a turorial out, which describes this?

If I rightclick on a table - filed: Is it possible to return the value of a
user written function?
I want to write a function which does some date calculations and return the
values to a number field. How can I do this?

Thanks for any help

Bruno
 
R

Rod Gill

What calculation do you want to do? Let us know as the simplest way for
Project 2000 on is to use a calculation.
 
B

Bruno

Hi Rod,

the calculations will be based on an external database, thats why I am
looking for a possibility to put the return values of a vba function into
THIS field.

How can I return the value of a vba function into a number1 field? Do I have
to loop through all tasks and access the field from there?

Regards
Bruno
 
J

Jan De Messemaeker

Hi,

activeproject.tasks("Task Name").number1=
activeproject.tasks(TaskID).number1=

You can indeed also loop through all tasks if you'r looking fore an other
field
or use the application.find function
 

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