Rabu, 03 Januari 2018

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: Art Lorenzini <dbalorenzini@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

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