1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
| Option Compare Database
#If VBA7 Then
Private Declare PtrSafe Function sndPlaySound Lib "winmm.dll" Alias "sndPlaySoundA" _
( _
ByVal lpszSoundName As String, _
ByVal uFlags As Long _
) As Long
#Else
Public Declare Function sndPlaySound Lib "winmm.dll" Alias "sndPlaySoundA" _
( _
ByVal lpszSoundName As String, _
ByVal uFlags As Long _
) As Long
#End If
Private Function Alarme()
sndPlaySound "c:\Windows\media\ring06.wav", &H1
End Function
Private Sub Effectué_Click()
DoCmd.RunSQL "UPDATE Rendez-vous SET Effectué = TRUE WHERE Numéro = " & Me("Numéro"), False
Me.RecordSource = "SELECT * FROM ReqRendez-vous WHERE Effectué = False"
Me.Requery
End Sub
Private Sub Form_Current()
End Sub
Private Sub Form_Open(Cancel As Integer)
' CommandBars("MenuContextuelPourFormulaires").Delete ' supprime la barre d'outils avant de la re-créer
Me.TimerInterval = 5000
Me.Controls("Effectué").SetFocus
End Sub
Private Sub Form_timer()
If Me.Recordset.RecordCount = Me.Recordset.AbsolutePosition + 1 Then
DoCmd.GoToRecord acDataForm, Me.Name, acFirst
Else
DoCmd.GoToRecord acDataForm, Me.Name, acNext
End If
DoEvents
If Me("Date-RV") > Me("Jour") Then
Me.Section(acDetail).BackColor = RGB(255, 255, 0) 'jaune
ElseIf Me("Date-RV") = Me("Jour") Then
Me.Section(acDetail).BackColor = RGB(128, 255, 128) 'vert
If Me("Maintenant") > Me("Heure-alarme") Then
Alarme
End If
Else
Me.Section(acDetail).BackColor = RGB(255, 128, 128) 'Rouge
End If
DoEvents
End Sub
Private Sub Nom_Click()
Debug.Print "Numéro : " & Format(Me.NumP)
Me.TimerInterval = 0 'Arrète la roue des rendez-vous
DoCmd.OpenForm "Personne", acNormal, , "Numéro = " & Format(Me.NumP), acFormReadOnly, acDialog
End Sub |
Partager