How to enable MS Access VBA debugging?

Question

This is really annoying. In MS Access VBA, there should be linebreak and debugging, however it always go through my code without hitting any of my breaks. Is there somewhere where I need to enable it first? I have the following option:

Option Compare Database
Option Explicit

Go to Tools>Startup>Advanced>Special Keys and make sure breakpoints aren't turned off. If that's not the issue try exporting the module/form, removing it, then re-importing it. — Tim Williams, Sep 23 '11 at 18:53
The fact is there are break points, and the ability to step through code line-by-line, and to check the call stack and everything else. What are your current settings? And what isn't working? Have you investigated the DEBUG and VIEW menus in the VBE? — David-W-Fenton, Sep 26 '11 at 20:27

score 8 · Accepted Answer · edited May 18 '13 at 12:27

8

I did face this issues in MS Access 2010.

All you need to do is uncheck "Use Access Special Keys"

Option available under Access Main Menu .. do the following:

Select File -> Options -> Select General Database

Check or uncheck "Use Access Special Keys"

Close and Open file and you are done.

edited May 18 '13 at 12:27

Artur Udod

4,465
1
29
58

answered May 18 '13 at 11:48

Zico

96
1
2

Thanks man, I already finished the project and moved on to other programs, but that's good to know. – Bill Software Engineer May 21 '13 at 13:16
"Check or uncheck": In my case it was unchecked and I had to check it. – Robin Dinse Jun 07 '20 at 04:41

score 2 · Answer 2 · answered Sep 24 '11 at 21:09

In VBE options, you need to make sure that the choices on the GENERAL tab are chosen correctly. I recommend these settings:

BREAK IN CLASS MODULE (not BREAK ON ALL ERRORS, because the latter will not show you which line in a class module has caused the problem)
COMPILE ON DEMAND turned OFF.

When you're coding, I recommend turning OFF AUTO SYNTAX CHECK on the EDITOR tab, because I can depend on the code turning red to tell me that it doesn't compile, without the interruption of a dialog popping up.

score 0 · Answer 3 · edited May 23 '17 at 11:59

0

I am sure you'd love this question. Check the answers. Mine is quite complete. erl and MZ-tools are the keys to "real" debugging in MS-Access

edited May 23 '17 at 11:59

Community

1
1

answered Sep 25 '11 at 17:31

Philippe Grondier

10,900
3
33
72

score 0 · Answer 4 · answered Sep 25 '11 at 17:46

0

You can also write Stop in your code to cause the debugger to break.

answered Sep 25 '11 at 17:46

Christian Specht

35,843
15
128
182

How to enable MS Access VBA debugging?

4 Answers4