[AccessD] Make query design view look like data view

Charlotte Foust cfoust at infostatsystems.com
Thu May 8 11:30:40 CDT 2008


LOL ... I think you need a class for that mumble mumble mumble


Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, May 08, 2008 9:08 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Make query design view look like data view

Look up thread "Column Positions" from 2007-04-01.

mumble mumble how do I do that mumble mumble never use the archives
mumble mumble apparently I need to mumble mumble

John W. Colby
www.ColbyConsulting.com


Gustav Brock wrote:
> Hi John
> 
> Look up thread "Column Positions" from 2007-04-01.
> 
> It can't be done but Shamil posted an alternative.
> 
> /gustav
> 
> 
>>>> jwcolby at colbyconsulting.com 08-05-2008 17:27 >>>
> Gustav,
> 
> That is what I am looking for.  I thought someone had code already
written.
> 
> Thanks for the info though.  I will go write the code if no one pops 
> up with it.
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> 
> Gustav Brock wrote:
>> 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