Opening to a Specific View

[James]

I set up a database a few years back to open to a specific table in it.
However, now I would like to change it to an opening screen that shows the
tables, queries, etc. along the left side and, in particular, I would like
it to show the items that are in a specific group on the left side. Is
there a way to do this? I am using Access 2003.

Thanks for any help.

James

 

[John Vinson]

I set up a database a few years back to open to a specific table in it.
However, now I would like to change it to an opening screen that shows the
tables, queries, etc. along the left side and, in particular, I would like
it to show the items that are in a specific group on the left side. Is
there a way to do this? I am using Access 2003.

Thanks for any help.

James

Sure; create a Form that displays the information you want to see
(perhaps using the MSysObjects table, or - better - a table that you
maintain showing user-friendly names of the objects). You'll need to
do the latter if you want to have objects in a "group".

You can use Tools... Startup to make this form open automatically.