[AccessD] Access 2007 - How to unfilter / unsort

Heenan, Lambert Lambert.Heenan at aig.com
Wed May 22 07:48:01 CDT 2013


' 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



More information about the AccessD mailing list