[AccessD] MS Access 2007 Subform Sort

Max Wanadoo max.wanadoo at gmail.com
Fri Sep 4 18:45:18 CDT 2009


Stuart,
You are sooo clever...do you know everything...?

How's about we go into business together...?

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: 05 September 2009 00:37
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] MS Access 2007 Subform Sort

You need to use that bl**dy ribbon.

On the left hand side of  the "Sort & Filter" group  are three icons
1. AZ and a down arrow
2. AZ and an up arrow
3. AZ and a rubber.

The tooltip for the third one is "Clear all sorts"

-- 
Stuart

 On 4 Sep 2009 at 18:52, Robert wrote:

> I'm not sure how else to explain this... 
> 
> In Access 2007 (and with an .mde) they added a small "down Arrow" dropdown
> box for each field header (column) for datasheet forms. Among a bunch of
> filter options, you have sort options A-Z and Z-A.
> 
> If you open Access 2007, open a form (with fields of course) in datasheet
> view, you will see what I'm talking about. It's completely Access driven,
no
> code needed at all. Not trying to change the record source, just trying to
> remove a sort via the same Access driven mechanism that allows you to
apply
> the sort.
> 
> 
> WBR
> Robert
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> Sent: Friday, September 04, 2009 6:21 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] MS Access 2007 Subform Sort
> 
> OH, yeah, sure.  In code.  In the click event of a command button or after
> update in a combo box.  So is that the case Robert?  Are you trying to
> change the record source of the subform to sort on a different field and
it
> doesn't seem to work?
> 
> Rocky
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
> Sent: Friday, September 04, 2009 2:38 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] MS Access 2007 Subform Sort
> 
> Rocky, maybe I am missing the question. If you have two sql one sorted by
> Name the other by ID (say) then it is possible to change the rowsource
from
> Qry 1 to Qry 2 of the form in code, is it not?
> 
> Max
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> Sent: 04 September 2009 22:19
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] MS Access 2007 Subform Sort
> 
> "because in a Access 2007 .mde you can apply a sort "
> 
> How do you do that in an mde?
> 
> Rocky
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert
> Sent: Friday, September 04, 2009 7:34 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] MS Access 2007 Subform Sort
> 
> Rocky,
>  It's strange, because in a Access 2007 .mde you can apply a sort (one for
> each field header), but it doesn't appear as if they give the option to
> remove the sort from a field.
> 
>  I can't even code against (beside removing ALL of the sorting) If the
user
> has sorted on more than one field then it's almost impossible to code a
> button on the main form to remove that one sort.
> 
>  Really starting to look like yet another MS monumental omission in
> features...
> 
> Thanks for responding Rocky! Oh BTW it's a program that I'm developing
(.mdb
> in Access 2007), I know call me crazy.. ;-)
> 
> WBR
> Robert
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> Sent: Friday, September 04, 2009 10:12 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] MS Access 2007 Subform Sort
> 
> I don't think they can.  Mde doesn't allow design changes.  Did they make
> the mde themselves? Do they have access to the mdb where they could do the
> change and then make the mde? It could be done through code, but they'd
have
> to implement that code in the mdb first, then compile.
> 
> Rocky
>  
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert
> Sent: Friday, September 04, 2009 6:50 AM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] MS Access 2007 Subform Sort
> 
> Ok,
>  How does a runtime .mde user remove a sort (Field Header) from a subform
> after applying it? I see no way to do this..? Is this a monumental
omission?
> 
> WBR
> Robert
> 
> 
> 
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.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