Compile Error : method or data member not found

[Mehran52]

When I try to search for anything I received this error,
Anybody knows what should i do?
I receive this error on Browse_All_Actions

If strError <> "" Then
MsgBox strError
Else
'DoCmd.OpenForm "Browse Actions", acFormDS, , strWhere, acFormEdit,
acWindowNormal
If Not Me.FormFooter.Visible Then
Me.FormFooter.Visible = True
DoCmd.MoveSize Height:=Me.WindowHeight + Me.FormFooter.Height
End If
Me.Browse_All_Actions.Form.Filter = strWhere
Me.Browse_All_Actions.Form.FilterOn = True
End If
End Sub

 

[Jeff Boyce]

Add a breakpoint to the routine in which the error occurs. Use this to
identify which command is causing the error.

By the way, I don't have enough information to tell what kind of object you
are referring to with the following lines:

Me.Browse_All_Actions.Form.Filter = strWhere
Me.Browse_All_Actions.Form.FilterOn = True

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Ken Sheridan]

It looks like you are filtering a subform. Where in the code you refer to
Browse_All_Actions this should be the name of the subform control, i.e. the
control in the main parent form's Controls collection which houses the
subform, not the name of the underlying form object, so if it’s the latter,
and the subform control is named differently, this would account for the
error.

Ken Sheridan
Stafford, England

 

[ole]

When I try to search for anything I received this error,
Anybody knows what should i do?
I receive this error on Browse_All_Actions

If strError <> "" Then
MsgBox strError
Else
'DoCmd.OpenForm "Browse Actions", acFormDS, , strWhere, acFormEdit,
acWindowNormal
If Not Me.FormFooter.Visible Then
Me.FormFooter.Visible = True
DoCmd.MoveSize Height:=Me.WindowHeight + Me.FormFooter.Height
End If
Me.Browse_All_Actions.Form.Filter = strWhere
Me.Browse_All_Actions.Form.FilterOn = True
End If
End Sub

 

[ole]

When I try to search for anything I received this error,
Anybody knows what should i do?
I receive this error on Browse_All_Actions

If strError <> "" Then
MsgBox strError
Else
'DoCmd.OpenForm "Browse Actions", acFormDS, , strWhere, acFormEdit,
acWindowNormal
If Not Me.FormFooter.Visible Then
Me.FormFooter.Visible = True
DoCmd.MoveSize Height:=Me.WindowHeight + Me.FormFooter.Height
End If
Me.Browse_All_Actions.Form.Filter = strWhere
Me.Browse_All_Actions.Form.FilterOn = True
End If
End Sub

 

[ole]

When I try to search for anything I received this error,
Anybody knows what should i do?
I receive this error on Browse_All_Actions

If strError <> "" Then
MsgBox strError
Else
'DoCmd.OpenForm "Browse Actions", acFormDS, , strWhere, acFormEdit,
acWindowNormal
If Not Me.FormFooter.Visible Then
Me.FormFooter.Visible = True
DoCmd.MoveSize Height:=Me.WindowHeight + Me.FormFooter.Height
End If
Me.Browse_All_Actions.Form.Filter = strWhere
Me.Browse_All_Actions.Form.FilterOn = True
End If
End Sub

 

[Mehran52]

Dear Shridan,

You are excellent , with this comment I solved my issues after around 1 week
so I can sleep comfortably ,

Thank you very much,
Mehran