[AccessD] Access 2007 - How to unfilter / unsort

No problem John. Been reading your stuff long enough to know when you're *really* being snippy. :-)

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W Colby
Sent: Wednesday, May 22, 2013 8:58 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 2007 - How to unfilter / unsort

LOL, right you are but this is ME doing this stuff.  And I absolutely allow ME to see the tables directly.  ;)

I am in development.  I am sorting a table to see newly created records etc.

I didn't mean to sound snippy.

John W. Colby

Reality is what refuses to go away
when you do not believe in it

On 5/22/2013 8:48 AM, Heenan, Lambert wrote:
> ' Not true and never has been.  You can go directly into a table.." True, never has been a good idea.
>
> Of course I *know* that you never let your users get to see a table 
> directly, that just bad practice/insanely dangerous to  data. And I 
> know, as the experienced developer you are that you are fully aware of 
> that. But developers make mistakes too. So I just try to stay away 
> from displaying tables directly. I see you got your solution to the 
> non-problem though. :-)
>
> Lambert
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W 
> Colby
> Sent: Tuesday, May 21, 2013 4:57 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Access 2007 - How to unfilter / unsort
>
> " the sort order of a table is undefined"
>
> True
>
> So if you want to see it in a particular order you have to write a query.
>
> Not true and never has been.  You can go directly into a table, click on the field header and execute a sort which will sort ascending / descending on that column.  This is just Access "helpful stuff" that has always been around.
>
> John W. Colby
>

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