1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| Private Sub Btn_exportation_Click()
Dim typeObjet As String
Dim ObjSource, ObjDestination As Object
Dim varItm As Variant
For Each varItm In Cmb_Selection_Objet.ItemsSelected
typeObjet = Cmb_Selection_Objet.Column(1, varItm)
Set ObjSource = CurrentData.AllTables(Cmb_Selection_Objet.Column(0, varItm))
Set ObjDestination = CurrentData.AllTables(Cmb_Selection_Objet.Column(0, varItm))
If typeObjet = "Table" Then
DoCmd.TransferDatabase acExport, "Microsoft Access", edtPath, acTable, Cmb_Selection_Objet.Column(0, varItm), Cmb_Selection_Objet.Column(0, varItm)
MsgBox "Transfert :" & Cmb_Selection_Objet.Column(0, varItm) & "-*- terminé-*-"
ElseIf typeObjet = "Requête" Then
DoCmd.TransferDatabase acExport, "Microsoft Access", edtPath, acQuery, ObjSource, ObjDestination
MsgBox "Transfert :" & Cmb_Selection_Objet.Column(0, varItm) & "-*- terminé-*-"
ElseIf typeObjet = "Formulaire" Then
DoCmd.TransferDatabase acExport, "Microsoft Access", edtPath, acForm, ObjSource, ObjDestination
MsgBox "Transfert :" & Cmb_Selection_Objet.Column(0, varItm) & "-*- terminé-*-"
End If
Next varItm
End Sub |
Partager