?
Solved

Access 2010 Group

Posted on 2011-09-29
6
Medium Priority
?
344 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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 

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 2000 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

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

589 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