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
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
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.
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