1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| Set db = CurrentDb
SQL = "SELECT T_LISTE_AC_DEF_INST.[Désignation AC],T_LISTE_AC_DEF_INST.[Position SI source] FROM T_LISTE_AC_DEF_INST WHERE T_LISTE_AC_DEF_INST.[Désignation AC]= 'ESSIEU MOTEUR ÉQUIPÉ';"
Set rst = db.OpenRecordset(SQL, dbOpenSnapshot, dbReadOnly)
INTITULE = rst("Désignation AC")
Nbpos = rst("Position SI source")
rst.Close
Set rst = Nothing
For i = 1 To Nbpos
Set db = CurrentDb
Set rst = db.OpenRecordset("T_ACI", dbOpenDynaset)
rst.AddNew
rst.Fields("Description POS") = INTITULE & " " & i
rst.Update
rst.Close
Set rst = Nothing
Next i |
Partager