[AccessD] Make query design view look like data view

Max Wanadoo max.wanadoo at gmail.com
Thu May 8 10:21:41 CDT 2008


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 



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list