A aliaslamy2k New member Local time Today, 03:53 Joined Oct 9, 2009 Messages 3 May 8, 2020 #1 Hi, I want some help on this error. I have changed names but still i am getting same error. Kindly advise if there is any ways for me to know what is causing this error. Attachments Error2.JPG 81 KB · Views: 109 Error3.JPG 80.6 KB · Views: 124
Hi, I want some help on this error. I have changed names but still i am getting same error. Kindly advise if there is any ways for me to know what is causing this error.
Uncle Gizmo Nifty Access Guy Staff member Local time Today, 00:53 Joined Jul 9, 2003 Messages 17,495 May 8, 2020 #2 My guess is, you can't have a subroutine named SearchAll. Change it to SearchAllX and give it a try.
Gasman Enthusiastic Amateur Local time Today, 00:53 Joined Sep 21, 2011 Messages 17,063 May 8, 2020 #3 Well you called your button the same name as your Sub in the form ? I tend to prefix my buttons with cmd ?
Well you called your button the same name as your Sub in the form ? I tend to prefix my buttons with cmd ?
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 07:53 Joined May 7, 2009 Messages 20,352 May 8, 2020 #4 rename Sub SearchAll() to Sub udfSearchAll() then call it: Private Sub SearchAll_Click() Call udfSearchAll() End Sub
rename Sub SearchAll() to Sub udfSearchAll() then call it: Private Sub SearchAll_Click() Call udfSearchAll() End Sub
A aliaslamy2k New member Local time Today, 03:53 Joined Oct 9, 2009 Messages 3 May 8, 2020 #5 Hello Uncle, It worked ! I changed the Sub name different. Thank you So much Attachments Solved.JPG 60.7 KB · Views: 130
A aliaslamy2k New member Local time Today, 03:53 Joined Oct 9, 2009 Messages 3 May 8, 2020 #6 arnelgp said: rename Sub SearchAll() to Sub udfSearchAll() then call it: Private Sub SearchAll_Click() Call udfSearchAll() End Sub Click to expand... Thank you so much Sir !
arnelgp said: rename Sub SearchAll() to Sub udfSearchAll() then call it: Private Sub SearchAll_Click() Call udfSearchAll() End Sub Click to expand... Thank you so much Sir !