breakpoint problem even when re-starting pc

[ARC]

This is strange... I set a break point on a form's code module, and then
after a bit, shut down the main program file. Now whenever I click the
button for the form, it opens the code module, with a highlighted line
(which is where I Had set the breakpoint). No matter what I do now, it
breaks out into the code module when I click the button. Even though there
is no longer a breakpoint there. I tried compacting / repairing, clearing
all break points, and even re-booting all with no luck.

I remember this happening on occasion in Access 97, but do not remember the
solution. And this is in Access 2007, so it looks like a bug that's carried
through over the years.

Any ideas?

Thanks!

Andy

['69 Camaro]

Hi, Andy.

Now whenever I click the button for the form, it opens the code module,
with a highlighted line (which is where I Had set the breakpoint).

Open the VB Editor. Click the "Reset" button on the toolbar three times if
you have database libraries or add-ins, or just twice if you don't have
either. Select the Debug menu -Compile <DatabaseName>, just in case the
code wasn't already compiled.

Press <ALT><Qto return to Access. Now, compact the database. When
finished, close the database. Open the database again and open the form in
Form View, then click on the button that has been causing the problem. The
problem should be gone because you've removed the ghost breakpoint.

And the next time you are stepping through code, don't make any changes to
the code. That's what causes the phantom breakpoints.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.

[ARC]

Thanks, Gunny!

The problem actually resolved itself after much more stepping through code,
etc. By the way, many a time when I have a breakpoint, I do end up altering
the code..

Andy

['69 Camaro]

You're welcome.

By the way, many a time when I have a breakpoint, I do end up altering the
code..

Break yourself of this habit in the VB Editor. It corrupts the code when
one or more versions of the code (there are 11 of them) can't synch. The VB
Editor isn't like other IDE's in this respect.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.

[Lou O]

On Sep 24, 2:22 pm, "'69 Camaro" <ForwardZERO_SPAM.To.
[e-mail]_SPAMwrote:

You're welcome.

By the way, many a time when I have a breakpoint, I do end up altering the
code..

Break yourself of this habit in the VB Editor. It corrupts the code when
one or more versions of the code (there are 11 of them) can't synch. The VB
Editor isn't like other IDE's in this respect.

HTH.
Gunny

Seehttp://www.QBuilt.comfor all your database needs.
Seehttp://www.Access.QBuilt.comfor Microsoft Access tips and tutorials.
Blogs:http://www.DataDevilDog.BlogSpot.com...utors2.htmlfor contact
info.

I had the same issue.
This is what Allen Browne advised.

1. Uncheck the boxes under:
Office Button | Access Options | Current Database | Name
AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Office Button | Manage | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile 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"

4. Open Access (holding down the Shift key if you have any startup
code),
and compact again.

5. Open a code window.
Choose Options on the Tools menu.
On the General tab, make sure Error Trapping is set to:
Break on Unhandled Errors
and the Compile on Demand is unchecked.

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

[Tony Toews [MVP]]

"ARC" <PC*****@PCESoft.invalidwrote:

>This is strange... I set a break point on a form's code module, and then
after a bit, shut down the main program file. Now whenever I click the
button for the form, it opens the code module, with a highlighted line
(which is where I Had set the breakpoint).

I just use the stop command now in the VBA and haven't bothered with breakpoints for
years.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

[John Mishefske]

Lou O wrote:

1. Uncheck the boxes under:
Office Button | Access Options | Current Database | Name
AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Office Button | Manage | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile 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"

4. Open Access (holding down the Shift key if you have any startup
code),
and compact again.

5. Open a code window.
Choose Options on the Tools menu.
On the General tab, make sure Error Trapping is set to:
Break on Unhandled Errors
and the Compile on Demand is unchecked.

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

I generally just open the problematic object, add a blank line and then
hit the backspace enough times to remove it. Then I close the object, do
a compile and save and the problem is gone.
--
'--------------------------
' John Mishefske
' UtterAccess Editor
' 2007 Microsoft Access MVP
'--------------------------