[AccessD] MS Access 2007 Subform Sort

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


Have you not heard of internet..i don't need to kiss him..

Max


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

The commute is a killer.

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 4:45 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] MS Access 2007 Subform Sort

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

-- 
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