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
|
Public Sub RechAss(ByVal Critere As String)
Dim rs As ADODB.Recordset
Dim cmdUR As ADODB.Command
Dim param As ADODB.Parameter
On Error GoTo HandleErr
modGestion.RAZ_Timout
Set cmdUR = New ADODB.Command
Set param = New ADODB.Parameter
With cmdUR
Set param = .CreateParameter("@Critere", adVarChar, adParamInput, 3500, Nz(Critere, 0))
.Parameters.Append param
.ActiveConnection = CurrentProject.Connection
.CommandText = "spAss"
.CommandType = adCmdStoredProc
Set rs = .Execute
End With
'Me.RecordSource = "EXEC dbo.spAss @Critere = """ & Critere & """"
Set Me.Recordset = rs
If Me.Recordset.Clone.RecordCount = 0 Then
cmbModif.Enabled = False
cmbSupprimer.Enabled = False
Else
cmbNouveau.Enabled = m_bCanAdd
cmbModif.Enabled = m_bCanModify
cmbSupprimer.Enabled = m_bCanDelete
End If
mnuOpe.Enabled = CBool(Nz(Me.IdAss, 0)) And m_bCanModify
mnuImprimer.Enabled = mnuOpe.Enabled
UpdateStaticFields
SetSubForms True
ExitHere:
On Error Resume Next
'Cleanup
Set param = Nothing
Set cmdUR = Nothing
Set rs = Nothing
Exit Sub
HandleErr:
Select Case Err.Number
Case Else
MsgBox "Error " & Err.Number & ": " & Err.Description, vbCritical, "Form_frmAss.RechAss" 'ErrorHandler:$$N=Form_frmAss.RechAss
End Select
Resume ExitHere
Resume
' End Error handling block.
End Sub |
Partager