Solved SOUND ON ERROR

[georg0307]

Dear All,

in attachment a very simple one field DB, I have created a formatting condition in order to avoid errors (begin with 9* and must be 9 characters.

Is it possible that on error the PC produce AN ALARM SOUND?

Thanks in advance

 

[GPGeorge]

Yes, that is possible. No, avoid it. That sound is going to become very annoying to users.

 

[isladogs]

Yes its possible but your users probably will dislike it and just set the speakers on mute.
However, feel free to use the alarm code part of my free utility

Countdown Timer

This countdown timer is similar to those found on smartphones. Use it to display remaining time (min/sec) during timed events. A choice of alarms are available to indicate when countdown has completed

www.isladogs.co.uk

 

[arnelgp]

you can use "beep"

DoCmd.Beep

 

[The_Doc_Man]

I tried this once. Took my users about 2 days to approach me with pitchforks and torches. They found that it was VERY annoying. They said "to err is human" - and they were VERY human.

The next version was much more visual and a LOT less noisy.

 

[georg0307]

Hi to All,

this DB works with a barcode reader wifi connected to pc so the sound is important, on error -- sound.
Thank you but I don't know how to do it.

 

[arnelgp]

add Validataion to textbox COLLI in design view of your form:

Private Sub COLLI_BeforeUpdate(Cancel As Integer)
Dim s As String
s = Me!COLLI & ""
If Left$(s, 1) <> "9" And Len(s) <> 9 Then
    DoCmd.Beep
End If
End Sub