Thanx for that tip, Bob! The command lets you run the procedure (and any procedures it may call), and go to the next line in the calling procedure. Now I can debug this code only with the help of putting a lot of message boxes, but it takes a lot of time... mx Capture1.gif 0 LVL 6 Overall: Level 6 MS Development-Other 1 Message Expert Comment by:TheQuietShadow2010-07-07 Comment Utility Permalink(# a33158164) You may mean safe mode: Hold Ctrl while opening Access 0 Check This Out
Technically, these are the only types of errors you can have, but we all know that Access can crash with a GPF. Know where procedures and variables are used. I was not able to find any option how it is possible to disable/enable VBA debugger, I supposed it should be always enabled. I recommend using “Break in Class Modules” which stops on the actual crashing line.
I must've unconsciously unchecked that option. RuralGuy View Public Profile Find More Posts by RuralGuy
Access and VB6 offers extremely powerful and flexible debugging tools and you should take advantage of them to minimize the time between discovering an error and fixing it. What is the code you are trying to step into? Just a thought. 0 LVL 84 Overall: Level 84 MS Access 83 MS Development-Other 14 Message Active today Expert Comment by:Scott McDaniel (Microsoft Access MVP - EE MVE )2010-07-07 Comment Allow Access Special Keys Access 2010 For instance, you may want to see if a file exists.
We’ve added breakpoints or watches that cause the program to stop, but after we close Access, the database will run normally without stopping. Aug 24 '12 #6 reply Expert Mod 100+ P: 2,316 TheSmileyCoder F9 is used to SET a breakpoint. I run my app from the main menu and it blows right on by the break point.>> Usually, that means simply that the code in question is not getting executed https://social.msdn.microsoft.com/Forums/office/en-US/3c03e09d-ed23-44ae-9a79-69de814c3730/vba-breakpoints-dont-work-anymore?forum=accessdev I couldn't get by without this forum.
This command actually causes an “error” and makes your program stop if Error Trapping is set to “Break in Class Modules”. Open Access In Debug Mode sorry, but I'm lost now. Thank you so much for all your help. so sorry,I was able to step through the code you gave me.
NoData4ThisReport.bmp 0 Message Author Comment by:Ted Palmer2010-07-08 Comment Utility Permalink(# a33164216) This is a screen shot of source code that has breakpoint and MsgBox with the tracer characters in them. i thought about this I seldom take the easy way, I don't give up easy, and that costs me dearly in time, but I learn a lot along the way. Debugging Access Vba Let's start with 2 simple message boxes, to verify that we can get the code running. Private Sub btnRun_Click() If gcfHandleErrors Then MsgBox "Setting error handler" How To Debug Access Database Ted Palmer 0 Message Author Comment by:Ted Palmer2010-07-08 Comment Utility Permalink(# a33168251) All, Update: I finally found one of my copies of "Northwind 2007.accdb" file.
mx 0 Message Author Comment by:Ted Palmer2010-07-08 Comment Utility Permalink(# a33164582) mx, I just saw your comment http:#33164391 I'll try that now. his comment is here TedPalmer 0 Message Author Comment by:Ted Palmer2010-07-07 Comment Utility Permalink(# a33158396) All, This has been happening this way before I added all the "On Error GoTo Err_Handler' stuff. boblarson View Public Profile Visit boblarson's homepage! Not only can you reduce bugs during development, you can also significantly reduce the effort required to replicate and fix bugs your users encounter. How To Debug Ms Access Code
debugging ms-access vba share|improve this question edited Sep 25 '09 at 8:44 Mitch Wheat 216k28347445 asked Sep 25 '09 at 8:42 Bogdan_Ch 2,38221531 add a comment| 2 Answers 2 active oldest Add the tables: Create the relationship: Decide if youâ€™re going to set referential integrity: Decide if you want cascade updaâ€¦ MS Access Advertise Here 764 members asked questions and received personalized Get 1:1 Help Now Advertise Here Enjoyed your answer? this contact form Aug 24 '12 #7 reply 100+ P: 142 benchpolo @ zmbd Thanks for the advise!
After enabling ALLOW ACCESS SPECIAL KEYSand restarting the database (still didn't work), I ran Compact and Repair, and it finally did the trick. Access 2010 Debug Window Oh! A few more points to note...
All my tables are linked to a MySQL database. In the Startup dialog box, click to select the Use Special Access Keys check box. Aug 24 '12 #5 reply Expert 5K+ P: 8,435 Killer42 Maybe I'm just way out of date, but I thought it was F9 to set a breakpoint in the code. http://amptools.net/ms-access/ms-access-nz-not-working.html My primary is VB.NET from the VS2008 IDE.
Other topic. Microsoft Access Runtime If you are deploying Microsoft Access databases with the free runtime version (to users who don't own Microsoft Access), the developer environment doesn't exist. i can't see any other reason for it not to respect the breakpoints gemma-the-husky View Public Profile Find More Posts by gemma-the-husky
So I'll get right back on this first thing in the morning. Is everything checked in the Startup menu? (Use Access Special Keys)?? __________________ (RG for short) aka Allan Bunch Previous MS Access MVP acXP, ac07, ac10, ac13 - WinXP Pro, Win7 Pro, warwica View Public Profile Find More Posts by warwica 07-05-2007, 12:32 PM #5 MsfStl Registered User Join Date: Aug 2004 Posts: 74 Thanks: 0 Thanked DBDarrell H Burns Monday, August 08, 2011 1:26 PM Reply | Quote 0 Sign in to vote One of the settings, just to be aware, is the ALLOW ACCESS SPECIAL KEYS