topic Re: VBA code in Access 2000 only works in debugger in Operating System - Microsoft

VBA code in Access 2000 only works in debugger

Dan Stauffer — Sun, 18 May 2003 11:29:09 GMT

I have some code that only works when I
"slow it down" by stepping through it in debugger w/ breakpoints inserted. The code seems to skip steps when I try to run it normally. Any idea why this is happening???

Re: VBA code in Access 2000 only works in debugger

Jon Finley — Sun, 18 May 2003 22:07:03 GMT

You may not be initializing some of your variables properly, or may not be passing the value correctly. Some debuggers initialize all variables rather than leave them as "undefined".

Create a "debug" window, place screen write points rather than breakpoints and run the program normally, collecting the variable changes in the window (or output to a printer or logfile).

Jon

Re: VBA code in Access 2000 only works in debugger

Jorge Pinto Leite — Mon, 19 May 2003 08:36:46 GMT

Dan, there are some VBA code that simply doesn't work if used without debugger. Let me explain better: suppose you have a report printer from a form, and you want to alter it's activate behaviour according to a variable in the form. Forget it. In debug mode you'll be able to do it. But not in "normal" mode.
Jorge

Re: VBA code in Access 2000 only works in debugger

Laurence Wingerter — Mon, 19 May 2003 15:10:15 GMT

Dan,
Sometimes today's machines are too fast. I've seen this before expecially when the code consists of various calls to other subroutines. Some commands invoke system routines that are multi-step.
Try injecting some "DoEvents" if there are places in the code that might fit what I have descibed. That'll give the system a chance to finish before continuing.