When coding, it's easy to make small mistakes. Usually these types of mistakes have no direct effect; the code runs and everything appears to be OK. That makes this situation so dangerous.
…
If you want to gain a quick overview of potential errors, you can use the free TM VBA Inspector. This add-in lets you browse the entire VBA code of an application for potential errors.
Source : Microsoft Access Team Blog