[AccessD] Access 2007 - How to unfilter / unsort

David McAfee davidmcafee at gmail.com
Tue May 21 14:35:39 CDT 2013


2010 is better, but still sucks in that regard.

I effing hate how print/print-preview (in both Excel and Access) takes you
to a different tab (File) .
The file menu should be a drop down menu, not a change of tabs (IMO).

D


On Tue, May 21, 2013 at 12:16 PM, John W Colby <jwcolby at gmail.com> wrote:

> I wasn't looking in the toolbar.
>
> Notice that you have to be in the home toolbar to even see that.
>
> Access 2007 (and above) is just clumsy to do real development in. I have
> been using it exclusively for almost 4 months now and still hate it.  Which
> toolbar was that XYZ in again?  Hmmm... let's click through all of them and
> look for it.  Oh and what exactly am I looking for anyway?
>
> Can you say major suckage?
>
> I can filter in the grid and clear the filter in the grid (right click
> menu).  I expected that since I could sort right in the grid, I could clear
> the sort right in the grid.  Uhhhh no.
>
> Can you say major suckage?
>
>
> John W. Colby
>
> Reality is what refuses to go away
> when you do not believe in it
>
> On 5/21/2013 1:01 PM, David A Gibson wrote:
>
>> I don't know about Access 2007 but in 2010 there is a "Clear All Sorts"
>> button beneath the ascending and descending arrows.
>>
>> David Gibson
>>
>> -----Original Message-----
>> From: accessd-bounces@**databaseadvisors.com<accessd-bounces at databaseadvisors.com>
>> [mailto:accessd-bounces@**databaseadvisors.com<accessd-bounces at databaseadvisors.com>]
>> On Behalf Of John W Colby
>> Sent: Tuesday, May 21, 2013 10:48 AM
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] Access 2007 - How to unfilter / unsort
>>
>> When I open a table I can set a sort order on a column, but when I click
>> the
>> little arrow, there is no clear filter.  Well... it is n't a filter it is
>> a
>> sort.  But there is no "clear sort" either.  So...
>>
>> When I sort a table (or query) on a column in the data grid, how do I
>> clear
>> the sort, short of closing the table without a save.
>>
>> --
>> John W. Colby
>>
>> Reality is what refuses to go away
>> when you do not believe in it
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
>> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>>
>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>


More information about the AccessD mailing list