Break points HELP!!

  • Thread starter Thread starter gdonald20
  • Start date Start date
G

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
 
Maybe you have the word "Stop" in your code. "Stop" means that the program
willl break there, at that point.
 
gdonald20 said:
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!!
Click to expand...


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.
 
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
Click to expand...

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.
 
gdonald20 said:
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
Click to expand...


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.
 
Back
Top