Beep when Record Appears

[Taff]

Strange question me thinks.

I have a form which is set to continous forms and requeries every 15 seconds.

When the form requeries it checks the records and if certain criteria includes those records.

What I am trying to do is when the form requeries, beep if anymore records appear.

Possible?

Thanks for any help.

Taff.

 

[KenHigg]

Hum...

How about this:

1. After you do a requery, do a dcount() and store the value.

2. When the next requery accures, do a new dcount() and compare the results an beep as required.

???
kh

 

[Taff]

Hi Ken,

Bit unsure how to do that, any pointers.

Thanks

Taff.

 

[KenHigg]

1. When the form opens, create a var named, named say intCurrentCount.
2. Then use a dcount() to determine how many records you have. Should be easy enough if your form is based on a query.
3. Store this in the inCurrentCount var.
- Form opens, and a requery kicks off
4. Do another dcount(), same as above
5. Compare this result to the intCurrentCount var
6. If Diff, then do a beep
7. Store the result on the last dcount() in the intCurrentCount var
- Timer kicks and requery happens again, etc.

There would be a problem with this if someone deleted old records and then another user added the same number of new records...

kh

 

[Taff]

Hi Ken,

Followed what you said and got it working in the end.

Thanks for ya help.

Taff.

 

[KenHigg]

.
.
.
.
.
Cool.