running days

[klp via AccessMonster.com]

I have a field that keeps track of the number of days a test has been running.
I have another field, completed. When the test is complete they will put a
check in the completed field. When the test is complete I would like the
field, running days, to change it's color to red and stop running. I know how
to change the color by writing code I just am unsure on how to code for the
field to stop running days. Any suggestions?

thanks in advance

KLP

 

[Damian S]

Hi klp,

I guess stopping the field running days depends on how it's running. If it
is an on timer event, you could always adjust your code so that it only
updates the field where Completed = False.

More info needed on how running days are being calculated if this isn't the
answer.

Damian.

 

[klp via AccessMonster.com]

Of course. Sorry I forgot to include the calculation for that. As of right
now I have it simple. Here is the calculation

Running Days:
=DateDiff('d',[SDate],Date())

SDate being the start date for that test.

Hi klp,

I guess stopping the field running days depends on how it's running. If it
is an on timer event, you could always adjust your code so that it only
updates the field where Completed = False.

More info needed on how running days are being calculated if this isn't the
answer.

Damian.

I have a field that keeps track of the number of days a test has been running.
I have another field, completed. When the test is complete they will put a

[quoted text clipped - 6 lines]

KLP