1 2 3 4 5 6 7 8 9 10 11 12 13
| Private Sub lc_Enter()
If Not Mode_debug Then On Error GoTo err
lc.RowSource = "SELECT 1*a.id_consommable as consommable, f.libelle as famille, sf.libelle as sous_famille, a.libelle, a.ref as reference, s.qte_stock as stock, u.libelle as unite, round(s.dern_prix_achat,2) as prix" _
& " FROM (((consommable a inner join stock_cons s on a.cd_consommable=s.cd_consommable) inner join unite u on u.cd_unite=s.cd_unite_stock)" _
& " inner join cons_famille f on f.cd_cons_famille=a.cd_cons_famille) inner join cons_ss_famille sf on sf.cd_cons_ss_famille=a.cd_cons_ss_famille " _
& "WHERE stock=1 and a.inactif=0" & IIf(mot_cle = "", "", " and a.ref like '*" & mot_cle & "*' or a.libelle like '*" & mot_cle & "*'") _
& IIf(x_f.Column(1) > 0, " and a.cd_cons_famille=" & x_f.Column(1), "") & IIf(x_sf.Column(1) > 0, " and a.cd_cons_ss_famille=" & x_sf.Column(1), "") _
& " order by 1;"
Exit Sub
err: Call message("Erreur " & err.Number & "/" & Erl & " dans DSM.lc : " & err.description)
End Sub |
Partager