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
| Private Sub btnPrint_Click()
'Filtrer '--- utile pour les états CngAgtListeDoc et CngAgtListeDoc2, inutile pour tAgtDOC4
'------- --------------- --------------- ---------------------
'Debug.Print Me.Filter
'DoCmd.OpenReport "CngAgtListeDoc", acViewPreview, , Me.Filter
'DoCmd.OpenReport "CngAgtListeDoc2", acViewPreview, , Me.Filter
Dim sFiltreDOC As String
sFiltreDOC = ""
If "" & Me.cbDir <> "" Then
sFiltreDOC = sFiltreDOC & " AND [AgtDirection]='" & Me.cbDir & "'"
End If
If "" & Me.TXTSITAgt <> "" Then
sFiltreDOC = sFiltreDOC & " AND [Agtsituation]='" & Me.TXTSITAgt & "'"
End If
If sFiltreDOC = "" Then
DoCmd.OpenReport "tAgtDOC4", acViewPreview
DoCmd.OpenReport "CngAgtListeDoc", acViewPreview
DoCmd.OpenReport "CngAgtListeDoc2", acViewPreview
DoCmd.OpenReport "CngAgtListeDoc3", acViewPreview
Else
DoCmd.OpenReport "tAgtDOC4", acViewPreview, , Mid(sFiltreDOC, 6)
DoCmd.OpenReport "CngAgtListeDoc", acViewPreview, , Mid(sFiltreDOC, 6)
DoCmd.OpenReport "CngAgtListeDoc2", acViewPreview, , Mid(sFiltreDOC, 6)
DoCmd.OpenReport "CngAgtListeDoc3", acViewPreview, , Mid(sFiltreDOC, 6)
End If
End Sub |
Partager