"Flashing" status indicators on a form

[Maloo]

I have a continuous form created that shows Estimated Project Start and Finish Date and also Actual Project Start and Finish Date fields.

I would like some type of indicator (red flag or green flag) to appear on the form that compares the Actual Start date to the Estimated Start date and shows red if late and green if early or on time. Same for comparing project finish dates.

So, there would be two "flags" appearing at the end of the screen showing start and finish status.

Any suggestions on how I could do this?

 

[jstutz]

What you are talking about is fairly easy to do on a SINGLE form. What you want to do is have both flags on your form and make one of the other visible depending on the record's data. On a continuous form, I haven't been successful at doing this b/c the method I am going to show you turns on the same flag for every record on the continuous form and not on a per record basis.

If you were to do it on a single form, here's what you would want to do:

- put both the Red Flag and the Green flag on the form and set the Visible property to "NO".
- In the Current Event, write a quick subroutine that turns on the appropriate flag depending on if the project started/ended on time.

'If proj started on time turn on Green Flag
If [estDate] >= [actDate] Then
Me![GreenFlag].Visible = -1
Me![RedFlag].Visible = 0

'If proj late, turn off Green and on red.
ElseIf [estDate] < [actDate] Then
Me![GreenFlag].Visible = 0
Me![RedFlag].Visible =-1

'If neither is true, keep both off.
ELSE
Me![GreenFlag].Visible = 0
Me![RedFlag].Visible = 0
End If

I don't know if this is a help to your or not, but I thought I would suggest it.

Jamie

 

[Carol]

For your information:

I have contacted Microsoft about formatting individual fields within individual records within a continuous form. It cannot be done. All records will change. This is something that they are aware of and maybe with the next release (200...) Access will be able to handle it. They did suggest searching their Users Forum of 27,000 queries, but a quick search did not prove useful. I have also been in contact with various authors who have written Access articles and books and again - it can't be done. So unless someone out there has developed some type of code that will handle this, we will have to wait.

[This message has been edited by Carol (edited 04-25-2000).]

[This message has been edited by Carol (edited 04-25-2000).]