Rocky Smolin
rockysmolin at bchacc.com
Fri Sep 4 18:43:32 CDT 2009
But will it work on a subform? I think that was his original question. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Friday, September 04, 2009 4:37 PM 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