Access should have an easy way to resolve Reference problems

At the moment when there is a bad reference you get an unhelpful error message: “Compile Error Can’t find project or library” and the code will break on a line containing the LEFT function.