asked on 1/20/2019

Hoping for short cut key to close vba windows in Access

I'm getting so tired of x' ing out of all of those visual basic windows in MS Access code view.
Had the same problem with A2K.. now using Office 365... have they added a function key or key shortcut for this yet???
I can't believe you experts deal with this problem..do you?

Thanks..p

Microsoft Office Microsoft Access

Last Comment

pcalabria

3/13/2019

PatHartman

1/20/2019

If your app keeps dropping into code windows, it is because you are not trapping errors correctly. From the VBA window, go to Tools/Options and look at the error trapping setting on the General Tab. Mine is set to break on unhandled errors. As I discover potential errors, I either fix them permanently if my code is the problem or add handlers to give users help in recovering from the problem without dropping into code.

crystal (strive4peace) - Microsoft MVP, Access

1/20/2019

here is some code you can use to close open modules in VBA:

VBA > Module > Close Open Windows
http://msaccessgurus.com/VBA/Code/Mod_CloseOpenModules.htm

~crystal

Daniel Pineault

1/20/2019

How exactly does it impact you if another window is open underneath the one you are working on? If they are maximized, you only see the one you are working on. I guess I'm just used to it.

Regardless, Mz-Tools add-in has a close all modules button amongst many other very valuable commands, definitely worth the price.

If you just want code, try

 Public Sub VBE_CloseAllModules(_
     Dim i As Integer
     Dim mods As Modules
     
     Set mods = Application.Modules
     For i = mods.count - 1 To 0 Step -1
         DoCmd.Close acModule, mods(i).Name, acSaveYes
     Next i
 End Sub

Open in new window

ASKER CERTIFIED SOLUTION