Organising a Database Window

[mmyne123]

Hello
I am slightly a neat freak, however I am creating a dbase that will have a quite a few different areas. Other than creating a blank form or table with a line as a name, is there a way of dividing up the dbase window in access to tidy it up.

So in other words, in the table area, I would like to create 5 areas, each have the same tables, but for a different company we own.

Can this be done?
Thanks in advance

 

[georgedwilkinson]

2007 has custom categories and groups.

 

[Banana]

If you're feeling old skool and like 8-tracks better than those newfangled CDs, and you jive on 2003 or even earlier, you also could create a group in the database and arrange them by groups.

There's a default group, "Favorites", but you can add your own (by right-clicking on the blank area), then select so and so objects to go into those groups.

The biggest downside of this, though, is that everything has to be done manually and like shortcuts, if you rename the original objects, the links within the groups won't work.

Alternatively, you could just create a form listing all tables, and use a table to categorize various objects. To find out how to get objects name, have a look at mvps.org/access website and search for database object name; they have code samples for getting the lists of objects within the database.

HTH.

*record scratching*

 

[boblarson]

So in other words, in the table area, I would like to create 5 areas, each have the same tables, but for a different company we own.

Same tables in the exact same tables or a similar table for each company (5 tables)?

 

[mmyne123]

Heh thanks for all the responses. Each group is a company carrying similar tables

 

[boblarson]

Why would you have separate tables for each company? Normally you would just store the data in one set of tables but limit the view of the data to each company in the forms and reports.