Accessing code window where is an error

[Design by Sue]

This has happened to me before and I had to force quit Access to solve it but there must be a better way.

I was entering code, but had not completed it and left access for another program on my computer. When I come back the form is displayed in the normal window but I can't access the code window because it is behind the normal view window and access just beeps at me. How can I get to the code window if I can't click on it when access is "locked" up because of a code error?

Sue

 

[apr pillai]

Try pressing ALT+F11 Keys. Repeating this shortcut keys should toggle the windows.

 

[David R]

Or Alt-Tab??

 

[Mihail]

or CTRL+Break

 

[Design by Sue]

Great - thanks - will try these next time it happens!

Sue

 

[Galaxiom]

Ctrl + Break halts the code execution. It can take a while.

Once it Breaks, bypass the code lines with the problem by commenting them out and hit the run button. This is particularly useful in functions where it is called from each record in a query. In that situation, hitting Stop just moves to the next record, repeats the call and the problem.

Moreover avoiding Stop preserves the project state so you don't lose variables.

Note that editing functions with a query open immediately applies the changed code to the values returned by the query so it will cause trouble if you edit something that causes an infinite loop or other problem.