Compile Error VBA Ms Acecss

[MUKESHY12390]

Hi All,

I have made some changes to macro which someone built in past, macro works perfectly without any debug.

there are several form on it , I changed the Control number and write new code (but didn't delete old control code is still there , although these lines don't affect the code)

since there several form and so many control on it with number of event, if I want to find all control which is not available in macro Is there any way I can find it.


eg: this is scenario I'm facing.. there was one commandButton called "Command11 and it had click event. later I changed the name and write new click event. problem is old one is still there and macro doesn't any alert for it.

Is there any way I can find these all control even with not exit in macro?

Private Sub Command11_Click()
'''this is old control called "Command11"
MsgBox "Hi"
End Sub


Private Sub cmd_test_Click()
'''this is old control with revised name
MsgBox "Hello World!"
End Sub

 

[MUKESHY12390]

I think I got the option, it is Debug --->Compile Database.


Thanks All!