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 62 63 64
|
Private Sub Form_Load()
Dim req_para As String
Dim mds_para As Recordset
Dim i As Integer
Dim txt As Control
Set madb = CurrentDb
req_para = "SELECT TBL_PARAMETRE.* FROM TBL_PARAMETRE WHERE ID_PARAMETRE = 1"
Set mds_para = madb.OpenRecordset(req_para, dbOpenDynaset)
mds_para.Edit
lst_sess.Value = mds_para("GVAR_SESS_PARAMETRE")
mds_para.Update
mds_para.Close
Me.Requery
For Each txt In Me.Controls 'parcour chaque contrôle du formulaire.
If TypeOf Ctl Is TextBox Then 'maintenant tu t'occupes de repérer le type de controle qui te convient
If Me("txt").Value = "" Then
Me("txt").Value = 0
End If
txt.AfterUpdate = calcul_montant()
End If
Next txt
'Set Ctl = Nothing
End Sub
Function calcul_montant()
Dim req, req_mtn_dep, req_mtn_rec, req_jour As String
Dim mds_mtn_dep, mds_mtn_rec, mtn_jour As Recordset
Dim mtn_dep, mtn_rec, nb_stag, nb_jour, liv_tee As Double
mtn_dep = 0
mtn_rec = 0
Set madb = CurrentDb
'----------------------------------
' source du formualaire
'_________________________________________________________________________
req = "SELECT TBL_SESSION.* "
req = req & "FROM TBL_SESSION "
req = req & "WHERE TBL_SESSION.ID_SESSION = " & lst_sess.Value
Me.RecordSource = req
ecetera..... |
Partager