Query or Table Description

[VB1022]

all my database are developed in Access 2003... When viewing the queries in
2003 there is a 'Description' field. This is always viewable for all queries
AND is sortable. I use this field to put my queries sequence... This is how
I know the sequence of queries to run - I sort this field.

I also use this field to put notation for Tables.

Now in 2007 this field requires a right click and only one query description
is available at a time... So now I'm lost, some of my DB's have up to 100
queries.

I'm praying there is a solution for this.... Help

Thank you,

Victor
(e-mail address removed)

 

[John W. Vinson]

all my database are developed in Access 2003... When viewing the queries in
2003 there is a 'Description' field. This is always viewable for all queries
AND is sortable. I use this field to put my queries sequence... This is how
I know the sequence of queries to run - I sort this field.

I also use this field to put notation for Tables.

Now in 2007 this field requires a right click and only one query description
is available at a time... So now I'm lost, some of my DB's have up to 100
queries.

I'm praying there is a solution for this.... Help

You may need to construct a table for this kind of documentation. You can fill
it by using VBA code to loop through the Querydefs and Tabledefs collections,
populating the table.

One thing I'd wonder about: is there only *ONE* sequence of queries? What are
all these queries anyway - action queries of some sort I presume?