Compile Errors Not Appearing

[MatthewR]

Any time I click on a command button which has a compile error in the code, I am no longer getting the error pop-up. It just simply does not run the code.



That would not be so bad in and of itself- but after it happens, I am unable to close the database.

What's going on, and how do I fix it?

Thanks for your help.

[John_G]

Always compile your code after making changes to it, and before you run it. In other words, in the VBA editor, do a Debug - Compile before saving. It's a good idea to do a compile from time to time anyway if you are making a lot of changes. Code errors can come back to bite you when you least expect it if you don't catch them first.

[Micron]

"Any time I click on a command button which has a compile error" - are we talking compile or run time error? A compile error runs when you try to compile or run code. A run time error only occurs when you try to run code. If your error only occurs at run time, it's not a compile error.
"I am no longer getting the error pop-up" - your code probably turned off warnings. At least I think it extends to run time errors as well as action queries, but I don't think it applies to compile errors.
It just simply does not run the code...but after it happens, I am unable to close the database. Likely your code is running - either a long query, or more likely, it is stuck in a loop. Suggest you copy the problem code and paste in a post (please use code tags) and we'll see if anything pops up.

[MatthewR]

Well, I don't have any code that's currently doing it because I fixed all my code. But to give you an example:

If 1 = 1 Then
    MsgBox "yep"

In the past, when I've had code like this, I'd get an error message that says "Compile Error: Block If without End If." However, I don't get those pop-ups anymore- it just does nothing.

[aytee111]

Maybe decompiling and recompiling will help (change as required):

"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile "c:\MyPath\MyDatabase.mdb"

[MatthewR]

Unfortunately, that did not work. However, it did solve another problem I was having in which Access was not recognizing a reference I had in vba, even though I checked off the correct object library. So, cheers on that.

[Micron]

Did you try creating a new db and importing all the objects into it from the problem db? I've never heard of your issue before. I presume this problem only occurs in one db and not all.

[MatthewR]

Yep that works!

FYI, this problem was occurring in multiple databases, but not all of them.

[MatthewR]

Oh, wait. When I re-open the new database, the same problem appears again. But when I open the database holding the shift key, it's fixed. I guess there's some code I'm running at startup that is causing this issue. I'll look through it and try to identify the problem.

[MatthewR]

Well, here's a strange conundrum. Even when I remove the AutoExec macro, I'm experiencing the same thing. If I open the database normally, I experience the problem- that is, no compile error messages. But if I hold the shift key when I open the database, then the compile error messages function as expected. I'm not sure why it's acting differently when I open with the shift key even when there is no AutoExec. Any ideas?

[aytee111]

From Microsoft: "When you open a database while holding down the SHIFT key, many of the options that are set on the Current Database page of the Access Options dialog box are bypassed."

I guess there is an option there - do let us know which one!

[John_G]

In the options for the database, is there a form that is selected to be opened on startup (Display Form..)? If there is, is there any code in its On load or On Open events?

[MatthewR]

John, there is a form that I open at startup with code in the On Load event. But even when I remove the macro that opens the form at startup, I still have the same problem.

aytee, do you have any idea which one of those options might be related to the problem? I just don't see any connection between any of those options and whether or not compile errors appear.

[ssanfu]

Maybe you could post your dB???

Do a "Compile and Repair", then Zip it. (Max Zip size is 2mb)

[MatthewR]

Okay, I've attached it. Let me know what you think, please.

(FYI, to get to design view, you may need to hold Shift when opening the db)

Federal Award Database.zip