Bonjour,

L'erreur 3075 apparaît et me dit qu'il y a une erreur de syntaxe mais je ne vois pas où

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
SQL = "INSERT INTO EquipmentCharacteristics ( IDCharacteristic , IDEquipment ,CharacValue )"
SQL = SQL & " SELECT  [CharacteristicsList].[IDCharacteristic], [Equipments].[IDEquipment], '*" & Me.txt_value & "*' "
SQL = SQL & " FROM CharacteristicsList, Equipments, EquipmentFamilies, EquipmentTypes"
SQL = SQL & " WHERE [Equipments].[IDEquipment] IN (SELECT [Equipments].[IDEquipment] FROM Equipments "
SQL = SQL & " WHERE [Equipments].[IDFamily] IN (SELECT [Equipments].[IDFamily] FROM Equipments "
SQL = SQL & " WHERE [Equipments]![IDEquipment] = "
SQL = SQL & cmb_IDEq & ") AND [Equipments].[IDType] IN (SELECT [Equipments].[IDType] FROM Equipments "
SQL = SQL & " WHERE [Equipments]![IDEquipment] = "
SQL = SQL & cmb_IDEq & ")) And [Equipments]![IDEquipment] != "
SQL = SQL & cmb_IDEq & ";"
Merci d'être mon sauveur