flashing field on a form

[Groundrush]

I keep a database for all our electrical work carried out and I am trying to log how many false alarm activations have occured at these properties.
Is there a way to have a field on the form that keeps count on how many times a choice from a combo box has been used for that Property? ie "False alarm"?
I need some sort of text field that flashes,beeps or gives the user an electric shock after 3 false alarm calls on that property.....ok maybe not a shock but I need to be able to keep track of these activations.

Looking forward to hearing from you Access Gods..

Thanks

 

[Jack Cowley]

I will let you figure out how to keep count of the number of alarms...

If you have a field called NoAlarms and a Label call NoAlarmsLabel then this code in the forms On Timer event should work for you:

If Me.NoAlarms >= 3 Then
Me.NoAlarmsLabel.Visible = Not Me.NoAlarmsLabel.Visible
End If
If Me.NoAlarms < 3 Then
Me.NoAlarmsLabel.Visible = True
End If

Set the Timer Interval to 600

 

[Groundrush]

Can I still use my combo box called Job Category with 3 choices
1) routine
2) break in
3) false alarm
to log the type of call?

then when I have found out how to keep count of all the false alarms on each Premises use that field called AlarmNo as you suggested?.

[This message has been edited by Groundrush (edited 05-18-2002).]

 

[Jack Cowley]

You can continue to use your combo box. I do not know how you have your db set up but it sounds like you have a Customer table and you may need an Incident table. The Incident table would be a record of each incident for each customer and a subform to the customers main form. I query can count the number of incidents for a selected customer from this table and tell you how my incidents were caused by a false alarm, routine or break-in.

 

[Groundrush]

The results I am looking for should be found in my query that my main form is based on
i.e Property and Job Category are included in it, cant I use that?
this is an example of what it looks like

Job category Property
ROUTINE Property 1
FALSE ALARM Property 2
FALSE ALARM Property 1
FALSE ALARM Property 1
FALSE ALARM Property 1
ROUTINE Property 2

I need to count on each Property and to flash when it reaches 3 false alarms
result Property 1= (3)...flashing label...
Property 2= (1)...not flashing...
thanks for your help

 

[Jack Cowley]

This is getting to far afield from your original query... You will need to sort it out using DCount a Totals query or some other function as I am unwilling to do the job for you... No offense intended Groundrush...

 

[Groundrush]

Thanks for your help
I will leave it at that for now, I will start over and do what you originally suggested