[AccessD] Access Requests

"My wish would be that the VBA editor only lists modules that have actually
been opened" Lambert

...amen to that!

William


--------------------------------------------------
From: "Heenan, Lambert" <Lambert.Heenan at aig.com>
Sent: Wednesday, July 23, 2008 2:26 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Access Requests

> I completely agree about how this is a case of "different strokes for
> different folks".
>
> As it happens I'm a keyboard shortcut collector. While I will often *look*
> at the taskbar to quickly check what's running, I almost invariably use
> Alt-Tab to jump between application. Here though I have to stress
> "Applications". To me MSAccess is one application, and if I happen to have
> four forms, a report and a couple of queries open in design view, I don't
> want to use half a dozen extra Alt-Tabs to cycle though all those Access
> windows, which is why I never have the option set. Once I get into the
> Access window it's second nature to me to use Ctrl-F6 to cycle though 
> *its*
> MDI windows, and to also use Ctrl-F4 to close the active one.
>
> As for the VBA editor, the way things work (in Access 2002) are kind of
> bizarre. I just opened an MS app, selected one module and hit the "Design"
> button. The VBA editor opens, but if you look at the Windows menu in the
> editor you'll see that what looks like *every* module in the application 
> is
> listed as Open - over 100 windows.
>
> So if you get your wish I for one hope that it will be a user selectable
> option. :-)
>
> My wish would be that the VBA editor only lists modules that have actually
> been opened
>
> Lambert
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jennifer Gross
> Sent: Wednesday, July 23, 2008 2:44 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Access Requests
>
> Hi Lambert,
>
> Interesting how different people see things differently.  I take no notice
> of the 'clutter' on the taskbar.  I move very, very quickly from one 
> window
> to another with Alt-Tab - almost never look to the taskbar to find the
> window I need.
>
> So, to hopefully use the proper jargon, my wish list for tools in Access
> that don't already exist is an option in the VBA editor to treat each MDI
> window (module) as a discreet SDI window, just like they have in the
> MSAccess application.
>
> Jennifer
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com