VBA - Debug

[Erwin Bormans]

Hi all

I'm developing a database in Access 2007. And use a lot of VBA code. Normaly
when you click in the grey bar in front of a code line, he puts a large red
dot in this grey bar and highlight that code line in red. When you run the
code he stops and that line and you can continue step by step.

But a few days ago and I didn't really notice when, he doesn't stop at that
line anymore.

I also discover some other problems with my switchboard, where I don't have
a clue how this could come.

Help would be very appriciated!

Kind regards
Erwin

 

[Tom van Stiphout]

On Tue, 8 Jan 2008 13:06:36 +0100, "Erwin Bormans"

This can typically be fixed by decompiling your database. Google for
the /decompile command line.
If that does not help, export all your objects to text and import them
back in. Lyle Fairfield just posted a utility for that.

-Tom.

 

[Dirk Goldgar]

Hi all

I'm developing a database in Access 2007. And use a lot of VBA code.
Normaly when you click in the grey bar in front of a code line, he puts a
large red dot in this grey bar and highlight that code line in red. When
you run the code he stops and that line and you can continue step by step.

But a few days ago and I didn't really notice when, he doesn't stop at
that line anymore.

I also discover some other problems with my switchboard, where I don't
have a clue how this could come.

Not stopping at a breakpoint might be the result of unchecking the option
"Use Access Special Keys". I don't recall offhand where that option is
located in Access 2007, but it should be in the startup options for "this
database".

If that's not it, it could possibly be the result of some corruption of your
VBA project, in which case a decompile may solve it.

If your problems with your switchboard persist, I suggest you post a
description of those problems.