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
| Private Sub Commande12_Click()
Dim bdFormation As Database
Dim rsDemander As Recordset
Dim rsSuivre As Recordset
Dim requete As String
Set bdFormation = CurrentDb()
requete = "select CodeSala, CodeForm, AvisSuper from DEMANDER where CodeSala ='" & Me.ListeDemandeur & "'" & " AND CodeForm ='" & Me.Modifiable0 & "'"
Set rsDemander = bdFormation.OpenRecordset(requete, dbOpenSnapshot)
If Not rsDemander.EOF Then
If rsDemander!AvisSuper = "D" Then
rsDemander.Close
Set rsDemander = Nothing
MsgBox ("Avis défavorable ... inscription impossible !!!")
Exit Sub
End If
If rsDemander!AvisSuper = "F" Then
Set rsSuivre = bdFormation.OpenRecordset("SUIVRE", dbOpenDynaset)
rsSuivre.AddNew
rsSuivre!CodeSala = Me.ListeDemandeur
rsSuivre!CodeForm = Me.Modifiable0
rsSuivre.Update
rsSuivre.Close
Set rsSuivre = Nothing
MsgBox ("Participation acceptée !")
End If
End If
rsDemander.Close
Set rsDemander = Nothing
End Sub |