Show All Groups in 2007

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.  
0
Utf
12/13/2007 9:20:00 PM
access 16762 articles. 3 followers. Follow

4 Replies
718 Views

Similar Articles

[PageSpeed] 45

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

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Christina" <Christina@discussions.microsoft.com> wrote in message
news:C30DDC50-59B6-4661-8864-14EC2381DCD1@microsoft.com...
> 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. 

0
Allen
12/14/2007 12:13:11 AM
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" wrote:

> 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
> 
> -- 
> Allen Browne - Microsoft MVP.  Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
> 
> "Christina" <Christina@discussions.microsoft.com> wrote in message
> news:C30DDC50-59B6-4661-8864-14EC2381DCD1@microsoft.com...
> > 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. 
> 
> 
0
Utf
12/14/2007 12:28:01 AM
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.

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Christina" <Christina@discussions.microsoft.com> wrote in message
news:1CE19A24-E847-4D80-A717-2A46944D712B@microsoft.com...
> 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" wrote:
>
>> 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" <Christina@discussions.microsoft.com> wrote in message
>> news:C30DDC50-59B6-4661-8864-14EC2381DCD1@microsoft.com...
>> > 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. 

0
Allen
12/14/2007 8:21:06 AM
Thanks again Allen!  To me, this is another of those...why would you change 
that?? kind of things...  _c



"Allen Browne" wrote:

> 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.
> 
> -- 
> Allen Browne - Microsoft MVP.  Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
> 
> "Christina" <Christina@discussions.microsoft.com> wrote in message
> news:1CE19A24-E847-4D80-A717-2A46944D712B@microsoft.com...
> > 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" wrote:
> >
> >> 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" <Christina@discussions.microsoft.com> wrote in message
> >> news:C30DDC50-59B6-4661-8864-14EC2381DCD1@microsoft.com...
> >> > 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. 
> 
> 
0
Utf
12/14/2007 12:57:02 PM
Reply:

Similar Artilces:

Archiving and Empty Trash Group Policies
I have Exchange Server 2003 SP2 on SBS 2003 SP1 server. I recently had to free up a lot of space our server hard drive. I think keeping my users mail boxes cleaned out would help, also. Is there a way to create a group policy to make sure that mail boxes are being cleaned out and archived to local hard drives to keep hard disk space freed up? Carl Gross <CarlGross@discussions.microsoft.com> wrote: > I have Exchange Server 2003 SP2 on SBS 2003 SP1 server. I recently > had to free up a lot of space our server hard drive. I think keeping > my users mail boxes c...

'Native code' showing in field that javascript fills out
I have added some javascript to write a value, when the onSave event is fired on a form, to a new field I have added . The result I get is a bit weird. The script I run is as follows. Please excuse me if this is not great syntax. I am new to javascript but this script does produce the result I am looking for in javascript editor. (crmForm.all.nf_nflowid.DataValue===null) { var dt = new Date() var d = dt.getDay() var m = dt.getMonth +1 var y = dt.getYear var h = dt.getHours var n = dt.getMinutes var s = dt.getSeconds var str1 = "nfq-" var str2 = "-...

Why isn't data that is automatically generated in my form showing up in table?
Ok, I've been messing with this problem all day (for those of you who have been following me, I'm so sorry!). But I think I finally figured out the root of my problem. I have created a form that allows users to enter in an employee's clock number using a combo box and it automatically generates the employee's name in a text box next to it by pulling information from the Employee Data table. This data shows up fine in the form view and the datasheet view. However, when I open the table up that this data is being saved to (Weekly Data), the data that has been automatically...

address book in outlook 2007
I moved my outlook mail file from an old computer to a new vista/office 2007 pc. the preconfigured mail file messed up and I imported my main into a new file. It seems to be working fine now. However, I don't have access to the contacts email addresses or any address book for that matter. I've tried: Click on the To button. If nothing shows, right-click on your Contacts in the folder list. Scroll to Properties. Click on the Outlook Address Book tab. Check the box that tells Outlook to show the folder as an address book. But the check box is grayed out. Any suggestions? tks....

how to load my office 2007 onto my netbook
i have office 2007 home and student which has been acrtivated once i now would like to load it onto my new netbook any ideas as to how i have no external cd/dvd drive "rob" <rob@discussions.microsoft.com> wrote in message news:2EF820C6-E56E-4704-86E4-ACE9DA5A5ECD@microsoft.com... > i have office 2007 home and student which has been acrtivated once i now > would like to load it onto my new netbook any ideas as to how i have no > external cd/dvd drive Copy the entire DVD to a Thumb drive and install from that. However, you may like to consider what metho...

Excel 2007 painfully slow.
As I've read about the Excel 2007 performance improvements that MS touts in Excel 2007 (http://msdn2.microsoft.com/en-us/library/aa730921.aspx, for instance), I've had to refrain from laughing out loud. For all I know, MS actually has managed to improve the calculation engine in 2007 -- but I wouldn't know, because for all the huge worksheets that I've built and worked with over the years, I've never had recalculation be the bottleneck. What I do know is that for the typical user in our organization, Excel 2007 is at least an order of magnitude slower than Excel 2003. To...

Outlook 2007 Message
WhenI send and receive mail a message pops up on the sreen saying: Contacting then server for information. It then runs the green bars kinda like it is completing something and goes away. My email seems to be working ok but this just started. Has anyone information on this? All comments are appreciated very much. Keith I see that sometimes when the image downloads are taking a long time. "Keith" <keithgirdley@blomand.net> wrote in message news:E4SdneZ1up-u-b7UnZ2dnUVZ_u-dnZ2d@neonova.net... > WhenI send and receive mail a message pops up on the sreen saying: > ...

Icon Handler's and Outlook 2007
I've written an Icon Handler shell extension that generates a custom icon (i.e. it provides a handle to the actual icon data rather than pointing Windows at a file with an icon index). The icon is based on the complete name of the file and not just the extension. This was working (although with a minor workaround) in outlook 2003. If the user attached a file, say, C:\afolder\afile.doc.ext, the icon handler would get called with C:\afolder\afile.doc.ext and then again with C:\<path to temporary internet files>\OLK1976\afile doc.ext The weird part for outlook 2003 was the conversio...

combining multiple calendars in Outlook 2007
Hi i have multiple calendars in outlook 2007. Any idea how I can combine the information into one single calendar? Thanks - Pete Open the Calendar you wish to copy, Change the Calendar view to By Category. Select the items you wish to copy to the main calendar, right click and drag to the main calendar in the left task pane. Drop and select COPY. The items will be copied to the main calendar. -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web si...

re: forms in ACCESS 2007
I just upgraded to ACCESS 2007, and so far have one difficulty. After I create a new form, and test it, it doesn't go true full screen. I can't get it to open without all the top Access menu bar being visible. How can I test it on a true full screen? Ctrl+F1 will minimize the ribbon. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Dave Hubbard" <dave.hubbard@sympatico.ca ( donotspam )> wrote in message news:CD6F99CE-B378-46D9-ADC3-2CA6B...

Print a form crashes Access 2007
I "copied" a form from a pdf, and "pasted" it to a create a form, and added fields to it and it worked fine, until recently. I tried to print it and Access "encounters an error". Since I couldn't figure it out, I recopied the form only from the pdf form and pasted it, creating a new form. I just tried to print the form without adding any fields, and it still "encounters an error" when I try to just print it. Other forms work, and this one used to...what in the world could this be, and how can I fix it. -- djkc55 ...

MS excell 2007 Data verification list
I am attempting to use the list function within data verification for drop down menus. I need a list that is conditional upon the information in another cell. Example: The first cell offers a drop down menu with specific Make of equipment. From what appears in that cell I seek to offer only the Models for that Make of equipment on a list in another cell. I considered using a series of IF statements to run macros however I don’t know how to invoke a macro from within a formula. Any suggestions? Thank You =if(“Trane”,macro,=If(Crrier,macro,=If(Bitzer,macro…))) See Debra D...

problem with conditional formatting and VBA (excel 2007)
Hello, i have a problem with conditional formatting and VBA (excel 2007). at first here is a screenshot of my conditional formula http://img156.yfrog.com/i/bugjz.png/ as you can see, the formula depends on B1 but it is relative. so far so good. but if i go through the cells with VBA the formula for all cells is the same, (e.g. =B4="yellow") if i do the same thing in excel 2003, vba shows the correct formulas: =B4="yellow" =C4="yellow" =D4="yellow" =E4="yellow" =F4="yellow" is this a known bug or do i something w...

Can't import Outlook Express into Outlook 2007
Here's the situation. user going from Outlook Express in XP [32-bit] SP3 to Outlook 2007 SP2 in Windows 7 64-bit. The old Outlook Express files [.dbx, etc.] are in a folder. When I try to import the messages into Outlook 2007, I specify import mail, choosing OE/WLM but it detects the never used WLM account [I thought it didn't come with win7 but it did pick up the dummy "Welcome to WLM" message]. It at no time asks to choose a folder or anything. Data was taken from a backup. Original computer was stolen. I know of a long way but is there anything faster? ...

OL 2007 Forms and not seeing new contacts created for the public G
A few years ago I created a form to be used with Exchange's public GAL. It has and is working OK. I am now running Windows 7 and Outlook 2007 and ran into this problem. When I go to the public GAL and create a new contact using a form I created after it is saved I don't see the contact. If I go to someone elses PC that is running Outlook 2003, I see the contact I just added and yes I have full Admin rights to my PC and the Exchange server. So I was wondering if the form could have something to do with it. If I right click on the GAL public folder and click properties and t...

Cannot add groups to Mailbox Rights.
Environment: Exchange 2003 running on Windows 2003. Forest and Domain are at Windows 2003 level. We have many group mailboxes that have a security group with Full Mailbox access granted to it. Yesterday when I went to Exchange Advanced >>> Mailbox Rights >>> Add I was able to add groups (or any security principal). Today the only object types I am able to add are "Users and Other objects". Evidently this does not include Groups, as they do not resolve. I am not aware of any changes that have been made to my account. I have checked with one other domain admin...

Excel 2007
When I right-click a cell to edit an existing cell comment in Excel 2007, the comment text box jumps down to row 399. My spreadsheet ends after row 50. I can edit the comment text box, but must then CNTL-Home to go back to the top of the worksheet and scroll to the area where I was working. This doesn't happen when creating a new comment, or when mousing over to view an existing comment--in both cases the comment is just to the right of the cell. Just happens when editing a comment. Does anyone know why this happens? I've made sure there is no formatting or other info in rows 5...

cell color does not show
When I fill a cell with color the color does not show on my worksheet but when I change to print preview I can see the color. How can I fix this? If the high contrast setting is turned on you won't see the fill colour. There's information in the following MSKB article: OFF: Changes to Fill Colour and Fill Pattern Are Not Displayed http://support.microsoft.com/?id=320531 mickid wrote: > When I fill a cell with color the color does not show on > my worksheet but when I change to print preview I can see > the color. How can I fix this? -- Debra Dalgleish Excel FA...

Hide or show Tag from VBA
When I rightclick a shape I can hide or show it's Tag. What are the commands to do that from VBA? Not exactly sure what you're talking about, but I'll take a guess. The shape you are using has a custom right-click, or context menu that allows you to hide and show some graphics. Inside the ShapeSheet for this shape is an Actions section. There will be a formula under the hide/show rows that looks something like one of these: SetF( "User.TagVisible", Not(User.TagVisible) ) SetF( GetRef( User.TagVisible ), Not(User.TagVisible) ) What you are looking for is th...

Show custom messes up my FREEZE PANE
When I use VIEW->Custom and any views I created, sometimes when I do a SHOW ALL, my FREEZE PANE is really messed up! Some times it will be off the screen and I can not get to the data at all until I UNFREEZE, and then I can reset the FREEZE PANE. I always only lock my HEADER row. Any ideas how to resolve this? What causes it? Thanks Bruce ...

Outlook 2007 / Importing addresses from Outlook Express
Is there a trick to this or is there an easy way to import my email addies from Outlook Express .wab files into Outlook 2007. I have over 4,000 email addies to transfer. Help PLEASE -- Jan Theres no trick, what happens when you import addresses? "Janice" <jan@alpacatyme.com[donotspam]> wrote in message news:B88C8B66-5308-4D6F-A87D-808ACE9555E3@microsoft.com... > Is there a trick to this or is there an easy way to import my email addies > from Outlook Express .wab files into Outlook 2007. I have over 4,000 > email > addies to transfer. Help PLEASE > -- ...

Acces to data base by autonom HTMl page on Access 2007 ?
Hello dear members of the microsoft.public.access newsgroup. I'm a new Access 2007 user and I need your help please. I can get acces to my data base using an autonom HTML form page in Access 2003 . Please, how can I do the same on Access 2007 ? I have neither SharePoint nor Outlook 2007. Thanks Octavio ...

Show file location in title bar?
Is there a way to make Excel or Word show the location of a file in the title bar. Right now, it just shows the name of the file. I was thinking in 2003, it showed the file location, or perhaps there was an option to show it? I can't find the same thing in 2007 and it would be extremely helpfull to have it! I use template files with the same name (for easy searching) but save in different client folders, which is why I want it to display the full path. Otherwise, I wouldn't care. Thanks!! I hope I am wrong but I don't think there is a setting for that. Yo...

Advanced Find for Customer Address does not show Parent id
I need to get a list of Customer Addresses with some criteria in Advanced find and I would like to see the Contact they are related to. I have selected the column parentid to be shown in the grid, but it is blank for all the rows. It seems to be a problem of rights but I am logged in as Administrator. Can anyone help me? Thanks, Anna ...

updated to 11.2.3 but only entourage notes shows up in .mac sync menu
so I would assume this means I can only sync notes. What about adresses and calendars? Any one have this issue? Any one solve it? Thanks in advance Entourage's addresses and calendar entries can be shared with Address Book and iCal, so you can keep using you traditional .mac synchronisation through the System Preferences for that. On 16.03.06 5:12, in article 1142485956.873353.220010@j33g2000cwa.googlegroups.com, "TripFoster" <trip.foster@gmail.com> wrote: > so I would assume this means I can only sync notes. What about adresses > and calendars? Any one have this...