1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| Private Sub Valider_Click()
If (DMax("[Pres_Dat]", "Adh_Pres_Jour", "[Pres_Dat]=date()")) Then
MsgBox "La journée de ce jour est déjà enrgistrée", vbOKOnly, "Confirmation"
DoCmd.GoToControl "Nul_F"
Else
DoCmd.OpenQuery "Ajout__Tbl_Adh_Pres_Jour", acViewNormal, acReadOnly
DoCmd.OpenQuery "Ajout_Tbl_Cpte_Table", acViewNormal, acReadOnly
DoCmd.OpenQuery "R1_AJ_Cotis_Pmt_Jour", acViewNormal, acEdit
MsgBox "MAJ effectuée", vbOKOnly, "Confirmation"
DoCmd.GoToControl "Nul_F"
End If
DoCmd.BrowseTo ObjectType:=acBrowseToForm, _
ObjectName:="F_Const_Tabl_Joueur", _
PathToSubformControl:="6_Parti.NavigationSubform", _
WhereCondition:="", _
Page:="", _
DataMode:=acFormEdit
End Sub |
Partager