Show All Groups in 2007

[Christina]

I've looked for this setting, but can't seem to find it -- or, maybe it's not
available (which would totally surprise me) -- is there a way to always "Show
All Groups" in Access 2007 as opposed to having to right click on the
navigation pane and activate all the time? I prefer to see all my objects at
once. Thanks for any help.

 

[Allen Browne]

Yes: the top of the Nav Pane has a drop-down. Choose:
All Objects.

To see them sorted like previous versions, right-click on the top of the Nav
Pane, and choose:
Category | Object Type

 

[Christina]

Thanks for the response -- let me rephrase a little -- unless I'm doing
something wrong, this seems to be something I have to do for every file I
open, it doesn't seem to be a permenant setting...I'd like every file I open
to automatically be set to show all objects. Thanks again for any help. _c

 

[Allen Browne]

AFAIK, this has to be set for each database, but you can get Access to
programmatically set these settings for all your databases.

The code is here:
http://allenbrowne.com/ser-69.html

You can even use Access 2003 to run the code if you need to. It sets several
properties for existing MDB files, so that the behavior is what you want for
all files. The article shows what to use for the constants at the top of the
code to get the behavior you want.

 

[Christina]

Thanks again Allen! To me, this is another of those...why would you change
that?? kind of things... _c