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 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70
| Option Compare Database
Private Const SW_SHOWDEFAULT = 10
Private Const SW_SHOWMAXIMIZED = 3
Private Const SW_SHOWMINIMIZED = 2
Private Const SW_SHOWMINNOACTIVE = 7
Private Const SW_SHOWNA = 8
Private Const SW_SHOWNOACTIVATE = 4
Private Const SW_SHOWNORMAL = 1
#If Win64 Then
Private Declare PtrSafe Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
#Else
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
#End If
Private Sub Btn_Effacer_Click()
Me.F_Pre -receiptsheet.Value = Null
Me.F_Famille.Value = Null
Me.F_Container.Value = Null
Me.F_Description.Value = Null
Me.F_PO.Value = Null
End Sub
Private Sub Btn_Recherche_Click()
'
' Fonction attachée au bouton permettant de modifier les filtres sur la recherche d'articles
'
On Error Resume Next
Dim SQL_String As String
SQL_String = "SELECT DT_Purchase_order.* FROM DT_Purchase_order"
'
' Initialisation du filtre afin de determiner si la concaténation de la châine commence par un where ou un and
'
Filtre_Actif = False
'
' Filtre désignation 'dans la châine'
'
CF_Filtre = Me.F_Pre - receiptsheet
If IsNull(CF_Filtre) Or CF_Filtre = "" Then CF_Filtre = ""
Select Case CF_Filtre
Case Is > ""
Select Case Filtre_Actif
Case True
SQL_String = SQL_String & " AND ((DT_Purchase_order.Purchase_order_Pre -receiptsheet) Like " & Chr(34) & "*" & CF_Filtre & "*" & Chr(34) & ")"
Case False
SQL_String = SQL_String & " WHERE (((DT_Purchase_order.Purchase_order_Pre -receiptsheet) Like " & Chr(34) & "*" & CF_Filtre & "*" & Chr(34) & ")"
End Select
'
Filtre_Actif = True
End Select
'
' Filtre Numero de container
'
CF_Filtre = Me.F_Container
If IsNull(CF_Filtre) Or CF_Filtre = "" Then CF_Filtre = ""
Select Case CF_Filtre
Case Is > ""
Select Case Filtre_Actif
Case True
SQL_String = SQL_String & " AND ((DT_Purchase_order.Purchase_order_Container) = " & Chr(34) & CF_Filtre & Chr(34) & ")"
Case False
SQL_String = SQL_String & " WHERE (((DT_Purchase_order.Purchase_order_Container) = " & Chr(34) & CF_Filtre & Chr(34) & ")"
End Select
'
Filtre_Actif = True
End Select
'
' Filtre Numero PO
' |
Partager