Private Sub FilterEnrg() Dim SQL As String SQL = " SELECT SYSTEM,SIMPLE,TYPE,WORKPERMIT,COMMENTS,REQUESTER,POSTE,TAGNAME,UNIT,FUNCTION,EQUIPMENT,LEVEL,STATUS FROM SSS WHERE ID <>0" If Me.CocherSSS Then SQL SQL & "OR SYSTEM 'SSS'" End If If Me.CocherPSS Then SQL SQL & "OR SYSTEM 'PSS'" End If If Me.CocherHIPS Then SQL SQL & "OR SYSTEM 'HIPS'" End If If Me.CocherPACK Then SQL SQL & "OR SYSTEM 'PACKAGE'" End If Me.RecordSource = SQL End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSet infoChange = New ADODB.Recordset infoChange.Open SQL
Adodc1.RecordSource = "Select * from Records Where Name like'" & Text17.Text & "%'" Adodc1.CommandType = ADODB.CommandTypeEnum.adCmdText Adodc1.Refresh()
Me.RecordSource = SQL Me.CommandType =ADODB.CommandTypeEnum.adCmdText Me.Refresh()