[AccessD] Make query design view look like data view

Hi Max

Oh, I didn't invent that, just recall faintly ...

As John, I think it was posted some time ago.

/gustav

>>> max.wanadoo at gmail.com 08-05-2008 17:21 >>>
You are one clever guy, Gustav.
Any code?
Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Thursday, May 08, 2008 4:17 PM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] Make query design view look like data view

Hi John
 
Loop through the fields of the query and - for each field - set the ordinal
position of the field to the index of the field?
 
/gustav
 


>>> jwcolby at colbyconsulting.com 08-05-2008 17:01 >>>
When you view data in a query you can move the fields around, slide this
field left, then this field right etc. If you SAVE the query after that,
then the fields when viewing data are in a different order than the fields
when viewing it in design. When it is a big query (lots of
fields) it is very confusing trying to find a specific field in design view
when it "should be" next to this field (as seen in the data view).

John W. Colby
www.ColbyConsulting.com