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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
| Option Compare Database
'------------------------------------------------------------
' Macro3
'
'------------------------------------------------------------
Function Macro3()
On Error GoTo Macro3_Err
DoCmd.SetWarnings False
DoCmd.OpenQuery "CDECLIENT", acViewNormal, acEdit
DoCmd.OpenQuery "F_ARTFOURNISSDEPOTPRINCIPAL", acViewNormal, acEdit
DoCmd.OpenQuery "F_ARTSTOCK CDEFournisseur", acViewNormal, acEdit
DoCmd.OpenQuery "F_ARTSTOCKQTES", acViewNormal, acEdit
DoCmd.OpenQuery "REQUETEFACTUREANNEE", acViewNormal, acEdit
DoCmd.OpenQuery "REQUETE AVOIR ANNEE", acViewNormal, acEdit
DoCmd.OpenQuery "Requête FA-AV ANNUELLES", acViewNormal, acEdit
DoCmd.OpenQuery "RequêteFA", acViewNormal, acEdit
DoCmd.OpenQuery "RequêteAV", acViewNormal, acEdit
DoCmd.OpenQuery "RequêteAVOIR FA-AV", acViewNormal, acEdit
DoCmd.SetWarnings True
DoCmd.OpenTable "MISE A JOUR", acViewNormal, acEdit
Exit Function
Macro3_Exit:
Exit Function
Macro3_Err:
MsgBox Error$
Resume Macro3_Exit
End Function
Dim strSQL As String
strSQL = "SELECT dbo_F_ARTICLE.AR_Ref, AVOIRmoisencours.SommeDeDL_Qte, VENTEmoisencours.SommeDeDL_Qte AS Expr1, NZ([VENTEmoisencours.SommeDeDL_Qte],0)+NZ(AVOIRmoisencours.SommeDeDL_Qte,0) AS SommeDeDL_Qte"
strSQL = strSQL & " INTO " & "T_" & Format(Date, "mmmm") & ""
strSQL = strSQL & " FROM (dbo_F_ARTICLE LEFT JOIN AVOIRmoisencours ON dbo_F_ARTICLE.AR_Ref = AVOIRmoisencours.AR_Ref) LEFT JOIN VENTEmoisencours ON dbo_F_ARTICLE.AR_Ref = VENTEmoisencours.AR_Ref "
strSQL = strSQL & " WHERE (((NZ([VENTEmoisencours.SommeDeDL_Qte],0)+NZ([AVOIRmoisencours].[SommeDeDL_Qte],0)) Not Like ""0""));"
DoCmd.RunSQL strSQL
End Function
End Sub |
Partager