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
| Private Sub Report_Open(Cancel As Integer)
Dim rst As DAO.Recordset, StrSql As String
requete = "SELECT ACCESS_ENTETES_VTES.NUM_ORD, ACCESS_ENTETES_VTES.TYP_PIE, ACCESS_ENTETES_VTES.CODE_STATUT, " _
& "ACCESS_ENTETES_VTES.COD_CLT, ACCESS_ENTETES_VTES.DAT_PIE, ACCESS_ENTETES_VTES.COD_REP, ACCESS_ENTETES_VTES.CLT_FAC, " _
& "ACCESS_ENTETES_VTES.FLG_MAJ, ACCESS_ENTETES_VTES.MT_HT, ACCESS_ENTETES_VTES.REF_CMD, ACCESS_ENTETES_VTES.SERIE_PIECE, " _
& "ACCESS_ENTETES_VTES.TYP_LIGNE, ACCESS_LIGNES_VTES.NUM_ORD, ACCESS_LIGNES_VTES.COD_ART, ACCESS_LIGNES_VTES.QUANTITE, " _
& "ACCESS_LIGNES_VTES.PU_BRUT, ACCESS_LIGNES_VTES.TAU_REM_1, ACCESS_LIGNES_VTES.PU_NET, ACCESS_LIGNES_VTES.COD_REP, " _
& "ACCESS_LIGNES_VTES.MONTANT_HT, ACCESS_LIGNES_VTES.DAT_LIV, ACCESS_LIGNES_VTES.FLG_MAJ, ACCESS_LIGNES_VTES.COD_CLT, " _
& "ACCESS_LIGNES_VTES.TYP_LIG, ACCESS_LIGNES_VTES.TYP_PIE, ACCESS_LIGNES_VTES.NUM_LIG, dbo_CLIENTS.COD_CLT, dbo_CLIENTS.NOM, " _
& "dbo_CLIENTS.ADR_1, dbo_CLIENTS.ADR_2, dbo_CLIENTS.ADR_3, dbo_CLIENTS.COD_PST, dbo_CLIENTS.VIL, dbo_CLIENTS.TEL, dbo_CLIENTS.TLC, " _
& "dbo_CLIENTS.TLX, dbo_CLIENTS.COD_FAM, dbo_CLIENTS.COD_SOU_FAM, dbo_CLIENTS.CPT_AUX, dbo_CLIENTS.CPT_CLF , dbo_CLIENTS.COD_TRF, " _
& "dbo_CLIENTS.PRC_REM, dbo_CLIENTS.COD_FAC, dbo_CLIENTS.FAC_POR, dbo_CLIENTS.FAC_FRA, dbo_CLIENTS.REP, dbo_CLIENTS.RGL, " _
& "dbo_CLIENTS.FLG_SML, dbo_REPRESENTANTS.COD_REP, dbo_REPRESENTANTS.NOM_REP, FamilleRegroupement.COD_REGROUPEMENT, dbo_ARTICLES.DGN, " _
& "dbo_MDR.LIB_RGL FROM (dbo_MDR INNER JOIN (dbo_REPRESENTANTS INNER JOIN " _
& "(ACCESS_ENTETES_VTES INNER JOIN dbo_CLIENTS ON ACCESS_ENTETES_VTES.COD_CLT=dbo_CLIENTS.COD_CLT) " _
& "ON dbo_REPRESENTANTS.COD_REP=ACCESS_ENTETES_VTES.COD_REP) ON dbo_MDR.MDR=dbo_CLIENTS.RGL) INNER JOIN " _
& "(FamilleRegroupement INNER JOIN (dbo_ARTICLES INNER JOIN ACCESS_LIGNES_VTES ON dbo_ARTICLES.COD_ART=ACCESS_LIGNES_VTES.COD_ART) " _
& "ON FamilleRegroupement.COD_FAMILLE=dbo_ARTICLES.COD_FAM) ON ACCESS_ENTETES_VTES.NUM_ORD=ACCESS_LIGNES_VTES.NUM_ORD " _
& "WHERE (((ACCESS_ENTETES_VTES.NUM_ORD)=Formulaires![Bon de commande]!NUM_ORD)And ((FamilleRegroupement.COD_REGROUPEMENT)=""3"" ));"
Set rst = Db.OpenRecordset(requete)
''Set rst = CurrentDb.OpenRecordset(StrSql)
If rst.EOF Then MsgBox "No data"
Set rst = Nothing
End Sub |
Partager