Group Sequence

[Marty]

I have created several groups in my mdb as I was
developing it. Now that development in nearly done, I
would like to resequence the groups so that they are more
structured for the end-user. (They could refer to the
list of groups as a check-list, etc)

Is there a way to resequence the groups without having to
delete and recreate them, then have to redo the shortcuts?

Also, is there a way to create "sub-groups"? For example,
a group might be called Data Entry, but sub-groups could
be data entry for specific tasks.

Thanks.

 

[Tim Ferguson]

I have created several groups in my mdb as I was
developing it. Now that development in nearly done, I
would like to resequence the groups so that they are more
structured for the end-user. (They could refer to the
list of groups as a check-list, etc)

It is obviously hard to know exactly what you are referring to here, but it
all sounds very non-Relational. Anything that happens in list (such as a
list of groups) should be in a table: and the way to sort that is with a
query ORDERed BY some suitable column in it. If the "groups" are types of
something, then they should be all in one table, and again a GROUP BY query
will get them out. Resequencing is simply a matter of choosing which column
or columns to sort by.

If you see what I mean...


B Wishes


Tim F

 

[Marty]

I am not referring to groups in the sense of grouping
data. I mean the groups area that appears on lower-left
on the main screen when the database is opened-under the
Favorites group standard.

Sorry about the confusion.

 

[Tim Ferguson]

I am not referring to groups in the sense of grouping
data. I mean the groups area that appears on lower-left
on the main screen when the database is opened-under the
Favorites group standard.

This is a tables and database design group: so we tend to think more about
schemas than Microsoft UI tricks! In general, the point of an application
is to keep users away from the actual Access objects such as the database
window, table grids and so on -- all interactions should ideally take place
through forms and reports. In many cases, however, that is probably an
aspiration rather than an actuality....

Best wishes


Tim F