Salut,
Peux-tu essayer en replaçant la ligne :
txtSQL="SELECT `NumDossier`, `xNumActe`, `xNumCommune`, `AnneeDossier`, `NumeroOrdre` FROM `xxxxxx`.`T_Dossiers` `T_Dossiers` WHERE `xNumActe` = " & listeActe.SelectedValue & " AND `xNumCommune` = " & ListeCodeCommune.SelectedValue & " AND `AnneeDossier` = " & me.getbyname("txtAnneeDossier").text & " AND `NumeroOrdre` = '" & NumOrdre.text & "'"
Par
txtSQL="SELECT ""NumDossier"", ""xNumActe"", ""xNumCommune"", `""AnneeDossier"", ""NumeroOrdre"" FROM ""xxxxxx"".""T_Dossiers"" ""T_Dossiers"" WHERE ""xNumActe"" = " & listeActe.SelectedValue & " AND ""xNumCommune"" = " & ListeCodeCommune.SelectedValue & " AND ""AnneeDossier"" = " & me.getbyname("txtAnneeDossier").text & " AND ""NumeroOrdre"" = '" & NumOrdre.text & "'"
Partager