Compile Error Problem

[jamason07]

Good Afternoon!

I have a database that I've built some buttons for that are running conditional macros. Everything was working fine yesterday but when I select one of the buttons, I get an error message that it can't find the form. The form is definately there and all the entries are correct. As I said...everything was working fine yesterday. The message goes on to say that the system may have encountered a compile error in a Visual Basic module for the form. I've checked the module and have cleaned up all the scripts....nothing unusual. I've compacted and repaired the Dbase. Suggestions?

JAM

 

[Edski]

JAM,
Try this:
Back up database. Double check that you've backed it up correctly.
Click Start - Run
Type: msaccess.exe /decompile "C:\myPath\myDB.mdb"
Cheers.

 

[jamason07]

Edski,

Thanks for the suggestion but it didn't work. The unusual thing is when I take out the conditions on the macro....the button works fine. The button also works when I include only some of the conditions but not all. I've run the step feature on the macro and there is nothing out of the unusual. When I have all the conditions in...it says it can't find the form.

JAM

 

[Edski]

what's the exact error message and does it let you debug?