1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Dim oDb As DAO.Database
Dim Req As QueryDef
'Instancie l'objet database
Set oDb = CurrentDb
With oDb
' Créé temporairement une requête
Set Req = oDb.CreateQueryDef("Request", _
"SELECT Tbl_TransfertJournee.Str_Ref, Tbl_TransfertJournee.Bool_Manufacture, Tbl_TransfertJournee.Bool_TypeTransfert" & _
" FROM Tbl_TransfertJournee" & _
" WHERE Bool_Manufacture=False And Bool_TypeTransfert=False;")
DoCmd.TransferText acExportDelim, "KanbanSpecExp", "Request", "C:\Documents and Settings\trc1tc\Desktop\Counda\Kanban.txt"
' Suppréssion de la requête
.QueryDefs.Delete ("Request")
Req.Close
End With |
Partager