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
| Private Sub Commande10_Click()
Dim varItem As Variant
Dim stDocname_etat As String
Dim stwhere As String
stDocname_etat = "E_Transmissions"
DoCmd.SetWarnings False
DoCmd.RunSQL ("Delete * From T_Temp_choixmodule")
For Each varItem In Me!Listemodule.ItemsSelected
DoCmd.RunSQL ("Insert into [T_Temp_choixmodule]([Choix_module]) values('" & Me!Listemodule & "')")
Next varItem
If DCount("Choix_module", "T_Temp_choixmodule") = 0 Then
Msgbox "Vous devez choisir une réa", vbOKOnly
Else
DoCmd.OpenReport stDocname_etat, acPreview
DoCmd.Close acForm, "F_transmissions"
End If
DoCmd.SetWarnings True
End Sub |
Partager