Compile Errors Not Appearing

[ssanfu]

OK, the biggest problem was that you are missing the two lines that should be at the top of EVERY module.


The lines are:

Option Compare Database
Option Explicit

I went through the code and cleaned/prettied it up.
I removed the look up FIELDS in the tables (they are now text boxes, not combo boxes).
I arranged the table fields - FK fields should be after the PK field, not halfway down the list of fields. (easier reading)
I renamed a couple of controls on "frmAwards"..... the list boxes now have a prefix of "cbo".

When creating bound controls, Access names the control the same as the field name. I always take the time to rename the control to avoid confusion. (I only renamed a few )

Yellow background controls (on forms) are how I indicate hidden controls. (frmAwards)

I did a /decompile, then compiled the dB.


Any errors with this dB??

[MatthewR]

Thanks. When I decompiled and compiled, I got an error on a couple vba lines that were like

DoCmd.OpenForm "frmMainMenu", acViewForm

It highlighted acViewForm and said Variable Not Defined. Not sure what's up with that, but I removed acViewForm since it's not really necessary anyhow.

Still not automatically getting compile errors, unless I proactively compile. I think I might just give up on that, though. Unless you have any other suggestions.

But those changes were good changes. Thanks for helping me out with that.

[ssanfu]

DoCmd.OpenForm "frmMainMenu", acViewForm

This errors because there is no parameter named "acViewForm". You would use "acNormal".

Are you expecting more compile errors? I don't get any more when I compile your code....
If you have "Option Explicit" at the top of every module, you only should get compile errors when you edit/add code. Errors in the code should be shown red.


Good luck with your project.

[MatthewR]

Thanks for the info.

I'm not expecting more compile issues with my current code, and compiling the database works just fine- when I compile, any errors generally come up.

My issue is that if I click a command button, or otherwise run code, and there is a compile error in that code, I don't get an error message. Access simply doesn't run the code and doesn't tell me why. And in some cases, it prevents me from closing the database afterward.

But it's an issue that I can live with.