Solved

Access 2010 Group

Posted on 2011-09-29
6
324 Views
Last Modified: 2013-11-29
In Access 2010, everytime I create a new table it creates a new subheading. I would like to move my tables under existing groupings then delete the old subheadings that Access has created. How do I do this? Many thanks.
0
Comment
Question by:NP111
  • 4
  • 2
6 Comments
 
LVL 7

Expert Comment

by:BusyMama
Comment Utility
For custom groupings, you should be able to drag and drop tables from one group to another.  Once a group is empty you can right-click and choose delete.

If you haven't created custom groupings it sounds like this is the way the tables and such are being shown in the panel.  If it says "Tables and Related Views" at the top of the navigation panel, click on this and choose "All Objects" instead.
0
 

Author Comment

by:NP111
Comment Utility
This is what I thought. However I cannot drag and drop any item listed. The ones in the template nor the new ones I created. There is no "all objects" option that I can see. Do you think these have been disabled when the template I dowloaded was created? It is not a web template.
0
 
LVL 7

Expert Comment

by:BusyMama
Comment Utility
Maybe ... are you able to post an empty copy of the database?

What happens if you right-click the top menu item on the navigation pane and choose Navigation Options - do you see anything there that you can check/uncheck?
0
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 

Author Comment

by:NP111
Comment Utility
The easiest thing is for you to download this template http://office.microsoft.com/en-gb/templates/CT010256691.aspx?tl=2#ai:TC010251225|. I am basically using this with added forms and fields and keeping most of the template intact.You will see from this template that the same thing applies.
0
 
LVL 7

Expert Comment

by:BusyMama
Comment Utility
Sorry I was away from the computer today but will check this out tomorrow.
0
 
LVL 7

Accepted Solution

by:
BusyMama earned 500 total points
Comment Utility
The template appears to be sorting and grouping by "Tables and Related Views".  This makes sense that you can't drag and drop into other groups.  For example, trying to drag the All Contributors report into the Campaigns area wouldn't make sense, since it isn't related to the Campaigns table.  Access will only allow you to do this once the item has a relationship with the parent.

If I create a custom group (right-click on "All Tables" and choose Category --> Custom) I am able to drag anything I want into and out of my custom group.

To "get rid of" the groupings that Access is currently using, click the drop-down arrow next to "All Tables" and choose "Custom" to use your custom groupings and none of the default groupings.

Hopefully that helps!
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now