debug toggle stuck?

  • Thread starter Thread starter Alison
  • Start date Start date
A

Alison

I'm utterly stumped. As long as I've been working with Access (10+ years),
I've never had this happen:

I have a button on a form that opens another form

Private Sub btnNewItem_Click()
DoCmd.OpenForm "ItemNew"
End Sub

Earlier this morning, I put a toggle on this docmd line, and on another line
of code elsewhere in my db.

Now, even though I've turned off the toggles, when my users click on the
NewItem button, the code stops at the above docmd line as though the toggle
is still on (only on this line, not on the other)! We've closed and
reopened the db several times. If I clear all toggles, it seems to stop,
but if we close/reopen, it's back again!

What in the world is going on, does anyone know???

TIA,
Alison
 
Hi Alison. By "toggle" I assume you mean break point?

Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

Then compact the database. The problem should be gone.
 
Back
Top