473,837 Members | 1,487 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Sep 24 '07 #1
6 5228
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.
Sep 24 '07 #2
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

Sep 24 '07 #3
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.


Sep 24 '07 #4
On Sep 24, 2:22 pm, "'69 Camaro" <ForwardZERO_SP AM.To.
69Cam...@Spamea ter.orgZERO_SPA Mwrote:
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.comf or all your database needs.
Seehttp://www.Access.QBui lt.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\m saccess.exe" /decompile
"c:\MyPath\MyDa tabase.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.

Sep 25 '07 #5
"ARC" <PC*****@PCESof t.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/
Sep 26 '07 #6
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\m saccess.exe" /decompile
"c:\MyPath\MyDa tabase.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
'--------------------------
Sep 26 '07 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
2183
by: Susan Bricker | last post by:
Hi. I am developing a database with Microsoft Access. When I run the application I get flipped into debug mode in the Visual Basic window at an old (unset breakpoint). I keep going to the Debug Menu and clearing all breakpoints, even though there are no breakpoints currently set. Yet, it still stops at the same location. Any ideas? I am running Access 2k3, but the database has been created to run on Access 2k.
4
2031
by: Wal Turner | last post by:
Consider the following simple class: public class ClassA { public static string VAR = "hello"; } public void MethodA() { while(true)
9
432
by: Tim Cali | last post by:
I set a breakpoint in a project, however the breakpoint is ignored. This was in the TimeTracker project from the Asp.Net site. I added it at the Login method of the TTUser class (TTUser.vb). I know I have the right insertion point where I want to begin stepping, because I changed "return username" to "return string.empty", and even when I put in the right login info, it doesn't let me enter the app. So this test told me that I have the...
7
1838
by: AC [MVP MCMS] | last post by:
Wierd situation here. Running ASP.NET 1.1 on Win2003. I have to manually attach the debugger to a process in order to debug. So I set a breakpoint in an obvious place (like within the Page.Load event) that will catch it. For Win2003, I attach to the w3wp.exe process. I've made sure my project is building as DEBUG. I've made sure the breakpoint it reachable. I've made sure my web.config has debug=true. But when I run through the...
3
2966
by: John Kutsor | last post by:
I have been working on a ASP.NET project with VB Code behind for a while now, and it ran perfectly up until now. When I try to set a breakpoint or a watch at certain parts of the project, even though that code executes, no break is made. I validated that it was making it up and after the breakpoint, but still no breakpoint execution or ability to create a watch.
5
1206
by: One Handed Man [ OHM# ] | last post by:
Pressing Button2 does cause the breakpoint shown in Button1's handler to be active the first time. After stopping the program and restarting it it break as soon as you start Button1, Any ideas what I might be doing wrong ? -- Best Regards - OHM O_H_M{at}BTInternet{dot}com -------------------- CODE BELOW ------------------
5
2085
by: DCC-700 | last post by:
I am using ASP.Net with VB on the 1.1 Framework running on Win XP Pro. I am trying to gauge the time it takes to sort a datagrid using different code sets. But when I am debugging the page there is a long delay before hitting breakpoint in page load. When I initially load the page I hit the breakpoint right away. Then I click on a Sort header in a datagrid, and it takes about 1:45 before the breakpoint (first statement in Page Load) is...
0
3181
by: noleander | last post by:
Hi. Ive been using Visual C++ for two years on an application. The application is one solution, containing 10 projects. 9 of the projects build libraries (*.lib). I've been debugging the application for 2 years. One thing that has been happening for several months is a genuine mystery: I cannot set breakpoints in one of the libraries (source code). I can create the breakpoint in the source code editor, but when I attach to the...
7
7509
by: =?Utf-8?B?TWljaGFlbA==?= | last post by:
Hi Everyone, I just started to get this error today. "The breakpoint will not currently be hit. The source code is different then the original. It seems to walk right over my breakpoints. I'm not sure whats going on here. I only have the code in one location, so I'm not sure why I'd get a message like this. Thanks for any suggestions. Michael Lee
4
4305
by: JohnR | last post by:
I understand the VS2005 still doesn't support data breakpoints in VB. My question is this.. does anybody know of a 3rd party product that DOES support data breakpoints in VB? As an aside, does anyone know why it seems to be so hard to impliment data breakpoints in VB? It is such a valuable tool. Thanks
0
9682
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10871
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10564
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9396
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6998
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5668
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5846
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4474
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3123
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.