Home > Ms Access > Ms Access Debug Not Working

Ms Access Debug Not Working


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.

Debugging Access Vba

I must've unconsciously unchecked that option. RuralGuy View Public Profile Find More Posts by RuralGuy

04-06-2008, 09:21 PM #6 simcha80 Registered User Join Date: Dec 2007 Location: Melbourne Posts: 6 Thanks: Maybe you want to test it multiple times and don’t want to enter it each time on the Immediate Window, or maybe the procedure call is too complex to use in Basic error handling just hides the default behavior and exits the program.

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.

Allow Access Special Keys

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

Thank you all.

On the Tools Menu, click Startup. Privacy Policy Site Map Support Terms of Use MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Courses Vendor Services Groups it does not stop at any of these places, then I would do what LSM suggested @http:#a33158762 mx 0 LVL 58 Overall: Level 58 MS Access 17 MS Development-Other 6 How To Debug Ms Access Forms At the most basic level, error handling involves two parts: Error Enabler This section invokes the error handler: On Error GoTo PROC_ERR If an error occurs in the procedure, the code

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

06-14-2007, 12:19 PM The equivalent to above would be: If x = 5 Then Stop Stop statements are rare but some developers like to add it to the end of Select Case statements for

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