Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access 2010 Group

Posted on 2011-09-29
6
Medium Priority
?
341 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 your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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…
Suggested Courses

824 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