Kamis, 04 Januari 2018

RE: [MS_AccessPros] VBA editor question

 

Art – another option is to use MZTools. One of its many features is an icon for closing all or all but the current window. It's no longer free, but is reasonably priced and, to me, well worth the money.

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals

MS Access MVP 2006-2016
That'll do IT http://thatlldoit.com

My Nothing-to-do-with-Access blog

https://wrmosca.wordpress.com

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, January 03, 2018 6:16 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] VBA editor question

 

 

Thanks Duane that worked liked a champ...

 


With Warm Regards,

 

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265  Ext. 130

Fax (605)964-1070

 

"Valar Dohaeris"




 


From: "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "dbalorenzini@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, January 2, 2018 5:01 PM
Subject: Re: [MS_AccessPros] VBA editor question

 

 

If I don't have too many open, I change the Windows view to Cascade. I can then quickly click to close them one by one.

 

You might want to consider this code. 

 

Duane

I use the following function to close all VBE windows Very useful when so many windows are left open you can't find anything. It also significantly speeds up loading ...

access-programmers.co.uk

 


From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, January 2, 2018 3:18 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] VBA editor question

 

 

I have Access 2016 but when I am in the VBA editor is there a way to close all the windows at once instead of one at a time. Its a little annoying especially after doing a project wide search.

 

 

 

 

Thank yo u,

 

Art Lorenzini

SD

 

 

 

__._,_.___

Posted by: "Bill Mosca" <wrmosca@comcast.net>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Posting Komentar