& "(" & Max & ",'" & Text_nomenf & "','" & Text2 & "'," _ & "'" & Text3 & "','" & Text4 & "','" & Text8 & "'," _
Comment arrivent les Items dans ta ListView ?mes items arrivent avec avec un RecordSet
Tu les insères avec un boucle ou bien s'agit-il d'un lien OLE avec un RecordSet ?
"quand j'enregistre une 301 personne dans ma base"j'enregistre mes données dans ma base avec insert into
Comment fais-tu ?
"c'est décalé dans ma listview"
Ce ne veut pas dire grand chose
'--Ajoute un nouvel enregistrement If nouv = True Then '-- cherche la cle la plus eleve de la table Set rs = New ADODB.Recordset rs.Open "select max(Num_ctr) as nouv from centre_aéré", Db If IsNumeric(rs!nouv) = False Then Max = 1 Else Max = rs!nouv + 1 End If rs.Close 'ajout article requete = "INSERT INTO centre_aéré (Num_ctr, nomenfant_ctr, prenomenfant_ctr, pere_ctr, mere_ctr, " _ & "emploi_ctr, adresse_ctr, commune_ctr, telfixe_ctr, telport_ctr, caf_ctr, sexe_ctr, " _ & "datenaiss_ctr, age_ctr, obs_ctr, cantjour, sncf, sem1_ctr, semjour1_ctr, sem2_ctr, semjour2_ctr, sem3_ctr, semjour3_ctr, sem4_ctr, semjour4_ctr, " _ & "sem5_ctr, semjour5_ctr, sem6_ctr, semjour6_ctr, sem7_ctr, semjour7_ctr, sem8_ctr, semjour8_ctr, semjour9_ctr) VALUES " _ & "(" & Max & ",""" & Text_nomenf & """,""" & Text2 & """," _ & """" & Text3 & """,""" & Text4 & """,""" & Text8 & """," _ & """" & Text5 & """,""" & C1 & """,""" & txt_telfixe & """," _ & """" & txt_telport & """,""" & Txt_caf & """,""" & comb_sexe & """," _ & """" & datenais & """,""" & Text7 & """,""" & txt_obs & """,""" & Label17 & """,""" & Label18 & """ ," _ & """" & Label20(0) & """,""" & Label20(1) & """,""" & Label20(2) & """,""" & Label20(3) & """," _ & """" & Label20(4) & """,""" & Label20(5) & """,""" & Label20(6) & """,""" & Label20(7) & """,""" & Label20(8) & """,""" & Label20(9) & """,""" & Label20(10) & """," _ & """" & Label20(11) & """,""" & Label20(12) & """,""" & Label20(13) & """,""" & Label20(14) & """,""" & Label20(15) & """,""" & Label20(16) & """ )" Db.Execute requete requete = "" MsgBox " La fiche de " & Text_nomenf & " " & Text2 & " à bien été Ajoutée ", _ vbInformation, "Mode Ajout" 'message pour ajout article Db.Close Unload Me Call iniliste(1) Call Rafresh("select * from centre_aéré order by nomenfant_ctr") Exit Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionexemple :
Code Visual Basic : & "(" & Max & ",'" & Text_nomenf & "','" & Text2 & "'," _
& "'" & Text3 & "','" & Text4 & "','" & Text8 & "'," _