Break points HELP!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gdonald20 - 10 Oct 2008 16:44 GMT

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

Reply to this Message

Vincent Verheul - 10 Oct 2008 17:40 GMT

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

> Hi
>
[quoted text clipped - 20 lines]
>
> Gillian

Reply to this Message

gdonald20 - 10 Oct 2008 20:55 GMT

Hi

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

Thanks

Gillian

> Maybe you have the word "Stop" in your code. "Stop" means that the program
> willl break there, at that point.
[quoted text clipped - 23 lines]
> >
> > Gillian

Reply to this Message

Marshall Barton - 10 Oct 2008 20:06 GMT

>I have an access 2000 application.
>
[quoted text clipped - 9 lines]
>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.

Signature

Marsh
MVP [MS Access]

Reply to this Message

John W. Vinson - 10 Oct 2008 21:16 GMT

>Hi
>
[quoted text clipped - 17 lines]
>
>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.

Signature

John W. Vinson [MVP]

Reply to this Message

Dirk Goldgar - 10 Oct 2008 23:52 GMT

> Hi
>
[quoted text clipped - 20 lines]
>
> 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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message