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