Step Through Code if Private Sub
in [Forms]
|
From: ryguy7272 on 6 Mar 2010 16:26 My code is like this: Private Sub CallQuery_Click() ....'lotsa stuff End Sub I had a heck of a time debugging something today because I couldn't step through the code like module-code. Finally got it! I could probably debug it much quicker if I could have stepped through the code. Is there a way to do this in a Private Sub like the above? Thanks! Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''.
From: Stefan Hoffmann on 6 Mar 2010 16:34 hi, On 06.03.2010 22:26, ryguy7272 wrote: > I had a heck of a time debugging something today because I couldn't step > through the code like module-code. Finally got it! I could probably debug > it much quicker if I could have stepped through the code. Is there a way to > do this in a Private Sub like the above? Set a break boint on the first line containing no declarative code and step through it. Take a look at the Debug menu. http://msdn.microsoft.com/en-us/library/aa189086%28office.10%29.aspx mfG --> stefan <--
From: Maurice on 6 Mar 2010 17:50 With the mouse click in the grey bar just before where you want to start debugging. A brown dot will appear. From that point on you can step through the code by pressing the F8 key. Like stefan mentioned there are various options to use in debug mode. B pressing F9 you can remove the breakpoint. -- Maurice Ausum "ryguy7272" wrote: > My code is like this: > Private Sub CallQuery_Click() > ...'lotsa stuff > End Sub > > I had a heck of a time debugging something today because I couldn't step > through the code like module-code. Finally got it! I could probably debug > it much quicker if I could have stepped through the code. Is there a way to > do this in a Private Sub like the above? > > Thanks! > Ryan-- > > -- > Ryan--- > If this information was helpful, please indicate this by clicking ''Yes''.
From: ryguy7272 on 6 Mar 2010 18:53 Thanks Stefan and Maurice. I tried your recommendation and this technique worked fine on two functions in my project. However, I could F8-through the code even w/out applying the break points. On the two Private Subs in my project, I still can't F8-through the code, even with the breakpoints in there. Shift+F8 is disabled and Ctrl+Shift+F8 is disabled too. Any thoughts? -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Maurice" wrote: > With the mouse click in the grey bar just before where you want to start > debugging. A brown dot will appear. From that point on you can step through > the code by pressing the F8 key. Like stefan mentioned there are various > options to use in debug mode. B pressing F9 you can remove the breakpoint. > -- > Maurice Ausum > > > "ryguy7272" wrote: > > > My code is like this: > > Private Sub CallQuery_Click() > > ...'lotsa stuff > > End Sub > > > > I had a heck of a time debugging something today because I couldn't step > > through the code like module-code. Finally got it! I could probably debug > > it much quicker if I could have stepped through the code. Is there a way to > > do this in a Private Sub like the above? > > > > Thanks! > > Ryan-- > > > > -- > > Ryan--- > > If this information was helpful, please indicate this by clicking ''Yes''.
From: Maurice on 7 Mar 2010 05:41 hmm weird, beacuse you should be able to step through the code. Is it possible for you to change the code? In that case typ the word "stop" without the quotes and try again. The code will stop at the word stop and that line will be yellow at breaktime. From that point on you should be able to step through with F8. Don't know why you aren't able to step through the other functions. There has to be something specific that makes it not 'steppable'. -- Maurice Ausum "ryguy7272" wrote: > Thanks Stefan and Maurice. I tried your recommendation and this technique > worked fine on two functions in my project. However, I could F8-through the > code even w/out applying the break points. On the two Private Subs in my > project, I still can't F8-through the code, even with the breakpoints in > there. Shift+F8 is disabled and Ctrl+Shift+F8 is disabled too. Any thoughts? > > > -- > Ryan--- > If this information was helpful, please indicate this by clicking ''Yes''. > > > "Maurice" wrote: > > > With the mouse click in the grey bar just before where you want to start > > debugging. A brown dot will appear. From that point on you can step through > > the code by pressing the F8 key. Like stefan mentioned there are various > > options to use in debug mode. B pressing F9 you can remove the breakpoint. > > -- > > Maurice Ausum > > > > > > "ryguy7272" wrote: > > > > > My code is like this: > > > Private Sub CallQuery_Click() > > > ...'lotsa stuff > > > End Sub > > > > > > I had a heck of a time debugging something today because I couldn't step > > > through the code like module-code. Finally got it! I could probably debug > > > it much quicker if I could have stepped through the code. Is there a way to > > > do this in a Private Sub like the above? > > > > > > Thanks! > > > Ryan-- > > > > > > -- > > > Ryan--- > > > If this information was helpful, please indicate this by clicking ''Yes''.
|
Next
|
Last
Pages: 1 2 Prev: Code not giving the correct results Next: Preparing a Access Database for a Website |