accde trouble

[gobeav3rs297]

So I just finished a project on Access 2007 and everything is working fine and dandy but once i saved the db project as an accde file every goes haywire. None of my queries work anymore, my search form no longer does anything, giving error msg of "Undefine function in expression". So why can't the query find the function inside my module when i saved it as an accde file?

-Vincent

Added 09/23/2007:

So i saved the original file as mdb format and then into .mde because i thought maybe it was a problem with the access 2007 format but the same problem presented itself again. So what am i doing wrong, is something messed up with the module when i convert it into an .mde format? it works perfectly when in regular format, someone please help.

 

[Lister]

Run the .mdb access file. When the error message runs, press Ctrl + Break. Select debug. This will take you to the module that is causing the error. Stop the module, set a break point at the start of the code. Then run the code, (open the query, click the button, whatever) the code with stop at your break point, step through the code by pressing F8.
As some point you will hit the line that is cuasing the error. Work out what you have done wrong and fix it.

65% of programing is fine tuning or debugging, so debuging skills are good to have.

Good luck pin pointing your error.