Solved

Access 2010 Group

Posted on 2011-09-29
6
328 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
ID: 36817000
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
ID: 36817155
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
ID: 36817243
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:NP111
ID: 36817558
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
ID: 36895014
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
ID: 36903766
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

831 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