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
|
Sub AjouterHeritiersEMS(IdMontDecl As Long, IdFond As Long)
On Error GoTo OUMAR
Dim bd As Database
Dim rs As Recordset
Dim sql As String
Set bd = CurrentDb
Set rs = Me.RecordsetClone
With rs
.MoveFirst
Do Until .EOF
If rs("ChoisirLesHEMS") Then
sql = "INSERT INTO Tbl_MontantLiquidePartgeHEMS" _
& "(NumEnregistreHEMS,NoFondatHEMS,MembresFamilleConcernesHEMS,StatutMembreFamil,PartPerçueHEMS,NumBienArgentHEMS) VALUES(" _
& fNumEnregistreHEMS() & ",'" _
& rs("NoFondateur") & "','" _
& rs("MembresFamilleConcernes") & "','" _
& rs("StatutMembreFamille") & "','" _
& rs("PartPerçue") & "','" _
& rs("NumBienArgentHEMS") & "')" 'F_RamenantTauxMembreFamilleEMS(Me.PartPerçue)
' insertion de l'enregistrement
bd.Execute sql, dbFailOnError
End If
.MoveNext
'________________________
Loop
End With
bd.Close: Set bd = Nothing
Forms("Frm_Fondateur").Controls("Tbl_MontantLiquidePartgeHEMS_SFrm").Requery
btAucun_Click
Exit Sub
OUMAR:
MsgBox Err.Description, vbExclamation, Err.Number
End Sub |
Partager