Prev: Viewing expressions in a listbox
Next: Duplicate a record
From: VB1022 on 24 Apr 2010 17:13
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
BELCOREV(a)CONED.COM
--
VICTOR
From: John W. Vinson on 24 Apr 2010 19:20
On Sat, 24 Apr 2010 14:13:01 -0700, VB1022 <BELCOREV(a)CONED.COM> wrote:

>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?
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: Viewing expressions in a listbox
Next: Duplicate a record