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
| Private Sub Commande211_Click()
On Error GoTo Err_Commande211_Click
Dim NumFAC As String
Dim stDocName As String
stDocName = "FORM-FACTURE FI"
DoCmd.OpenForm stDocName, acNormal, "", "", acAdd, acNormal
Forms![FORM-FACTURE FI]![ID_Devis] = IDDevis
Forms![FORM-FACTURE FI]![id_FI] = IDFiche
Forms![FORM-FACTURE FI]![ID_Client] = IDClient
Forms![FORM-FACTURE FI]![ID_Site] = IDSites
Forms![FORM-FACTURE FI]![ID_Analaytique] = IDAnalytique
Forms![FORM-FACTURE FI]![id_categorie] = IDCategorie
Forms![FORM-FACTURE FI]![Objet] = Observations
Forms![FORM-FACTURE FI]![id_tva double] = [TVA FI]
Forms![FORM-FACTURE FI]![Texte] = Observ2
Forms![FORM-FACTURE FI]![Type facture] = Typefacture
Forms![FORM-FACTURE FI].Refresh
'Récupérer le numéro de fiche intervention en cours
NumFAC = Forms![FORM-FACTURE FI]!IDFACTUREFI
monsql = "INSERT INTO [RQ-DETAIL FAC] ([ID_Facture FI], ID_FI, [ID_ARTICLE], TVA, SOUSARTICLE, [PVHT Fac], [QteDetailFac])" _
& " SELECT [Formulaires]![FORM-FACTURE FI]![IDFACTUREFI] AS NumFAC,[RQ-DETAIL FI].id_FI," _
& " [RQ-DETAIL FI].id_article, [RQ-DETAIL FI].TVA, [RQ-DETAIL FI].SousArticle, [RQ-DETAIL FI].[PVHT FI], [RQ-DETAIL FI].[Qte DetailFI]" _
& " From [RQ-DETAIL FI]" _
& " WHERE [RQ-DETAIL FI].id_FI ='" & Me.IDFiche _
& " AND [RQ-DETAIL FI].[Select]=-1 AND [RQ-DETAIL FI].Facture=0;"
DoCmd.RunSQL monsql
monsql = "UPDATE [RQ-DETAIL FI] SET [RQ-DETAIL FI].Facture = -1" _
& " WHERE [RQ-DETAIL FI].id_FI ='" & Me.IDFiche _
& " AND [RQ-DETAIL FI].[Select]=-1 AND [RQ-DETAIL FI].Facture=0;"
DoCmd.RunSQL monsql
Exit_Commande211_Click:
Exit Sub
Err_Commande211_Click:
MsgBox Err.Description
Resume Exit_Commande211_Click
End Sub |
Partager