1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| Private Sub btnTest_Click()
Dim SQL As String
Dim qd As QueryDef
SQL = "SELECT Entree.NEntree, Entree.DateEntree, Entree.NProjet, Entree.NAttribution , Entree.NUtilisateur, Entree.NCommandeMaxima, Entree.LieuE, EntreeDetail.NProduit, Produit.Designation, Produit.RefFournisseur, EntreeDetail.QteEntree, EntreeDetail.PxUnitaire FROM Produit INNER JOIN (Entree INNER JOIN EntreeDetail ON Entree.NEntree = EntreeDetail.NEntree) ON Produit.NProduit = EntreeDetail.NProduit WHERE EntreeDetail.QteEntree>0 "
SQL = SQL & " And Entree!DateEntree=#" & Format(DateEntree, "MM/DD/YYYY") & "#"
SQL = SQL & ";"
Debug.Print SQL
Set qd = CurrentDb.CreateQueryDef("Requete_Entree", SQL)
DoCmd.OutputTo acQuery, "Requete_Entree", "MicrosoftExcelBiff8(*.xls)", "C:\Documents and Settings\guest\Mes documents\Entree_" & DateEntree & ".xls", False, "", 0
DoCmd.DeleteObject acQuery, "Requete_Entree"
End Sub |
Partager