Break points HELP!!

[gdonald20]

Hi

I have an access 2000 application.

I have various code on the on open event of the welcome menu form, which i
wanted to test today. I put breakpoints in the code to test and then when
finished i cleared the breakpoints.

but..............

They haven't gone away, everytime i open the database it breaks into the
code where my breakpoint was, i've tried everything i can think of, ie debug,
compact, i've even put the break point back on saved the code and saved the
form, then taken it back off saved the code and the form, and it still breaks
there!!

Any help would be greatly appreciated

Thanks

Gillian

 

[Vincent Verheul]

Maybe you have the word "Stop" in your code. "Stop" means that the program
willl break there, at that point.

 

[Marshall Barton]

I have an access 2000 application.

I have various code on the on open event of the welcome menu form, which i
wanted to test today. I put breakpoints in the code to test and then when
finished i cleared the breakpoints.

but..............

They haven't gone away, everytime i open the database it breaks into the
code where my breakpoint was, i've tried everything i can think of, ie debug,
compact, i've even put the break point back on saved the code and saved the
form, then taken it back off saved the code and the form, and it still breaks
there!!

That sounds like the module could be corrupted.
Here's a helpful web page http://allenbrowne.com/ser-47.html

I think a Decompile might be called for. Take a look at the
Symptom: "An error occurred while loading Form_FormName" on
the above page.

 

[gdonald20]

Hi

I definitely don't have the word stop in my code so it's not that.

Thanks

Gillian

 

[John W. Vinson]

Hi

I have an access 2000 application.

I have various code on the on open event of the welcome menu form, which i
wanted to test today. I put breakpoints in the code to test and then when
finished i cleared the breakpoints.

but..............

They haven't gone away, everytime i open the database it breaks into the
code where my breakpoint was, i've tried everything i can think of, ie debug,
compact, i've even put the break point back on saved the code and saved the
form, then taken it back off saved the code and the form, and it still breaks
there!!

Any help would be greatly appreciated

Thanks

Gillian

A couple of suggestions:

1. Open the VBA editor and select Debug... Clear All Breakpoints. Compile the
database, compact and repair, and see if that fixes it.
2. Decompile the database. In the Start... Run window, or in the command line
of a shortcut, put

"C:\Program Files\<some path>\msaccess.exe" "K:\path\x.mdb" /decompile

Then open the database, compact it, open the VBA editor, compile, and compact
again.

 

[Dirk Goldgar]

Hi

I have an access 2000 application.

I have various code on the on open event of the welcome menu form, which i
wanted to test today. I put breakpoints in the code to test and then when
finished i cleared the breakpoints.

but..............

They haven't gone away, everytime i open the database it breaks into the
code where my breakpoint was, i've tried everything i can think of, ie
debug,
compact, i've even put the break point back on saved the code and saved
the
form, then taken it back off saved the code and the form, and it still
breaks
there!!

Any help would be greatly appreciated

Thanks

Gillian

Open the form in design view. Open the form's code module in the VB editor.
Modify any line of code slightly, maybe just by entering a space at the end
of the line, or deleting and then restoring a letter. Click Debug -> Clear
All Breakpoints. Click Debug -> Compile. Click the Save button, and close
the form.

Usuallly, though not always, that's enough to clear the phantom breakpoints.