Event Procedure

[Guest]

When I open up the Event Procedure to enter in new codes I get a cascade
effect. I have, it seems all the Event Procedures for the entire data base
piled one on top of the other with the one that I want on top. This becomes
annoying. What causes this and can it be stopped.

 

[Brendan Reynolds]

When you open the VBA editor, it opens all of the code windows that were
open the last time you performed a save in the VBA editor.

To prevent unwanted windows from being opened, first you need to change
something in the code, because the Save command is ignored if nothing has
changed since the last save. You can just put in a blank line somewhere and
then backspace it out again, if you like.

Now close all windows except those you want opened next time you open the
VBA editor, if any, and do a save from within the VBA editor - choose the
Save command from the VBA File menu, click the diskette icon on the VBA
toolbar, or use the Ctrl+S keyboard shortcut.

Close the VBA editor, and when you re-open it you should see only the code
windows that were open when you saved.

 

[Guest]

Hi Sandrao,

You can maximise the screen.......
If you close each one down one-by-one they will stay that way during that
session (unless you compact and repair the database at which point they
re-appear)
As far as I know, there is no way of stopping this behaviour, sorry.

TonyT..