Solved SOUND ON ERROR (1 Viewer)

georg0307

Registered User.
Local time
Today, 20:04
Joined
Sep 11, 2014
Messages
91
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
 

Attachments

  • ARCESE_PICK_SHIP.zip
    30.6 KB · Views: 84

GPGeorge

Grover Park George
Local time
Today, 12:04
Joined
Nov 25, 2004
Messages
1,776
Yes, that is possible. No, avoid it. That sound is going to become very annoying to users.
 

isladogs

MVP / VIP
Local time
Today, 19:04
Joined
Jan 14, 2017
Messages
18,186
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
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 03:04
Joined
May 7, 2009
Messages
19,169
you can use "beep"

DoCmd.Beep
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 14:04
Joined
Feb 28, 2001
Messages
26,999
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

Registered User.
Local time
Today, 20:04
Joined
Sep 11, 2014
Messages
91
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

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 03:04
Joined
May 7, 2009
Messages
19,169
add Validataion to textbox COLLI in design view of your form:
Code:
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
 

Users who are viewing this thread

Top Bottom