Stuart McLachlan
stuart at lexacorp.com.pg
Fri Sep 4 19:59:12 CDT 2009
As GBS put it: "two countries separated by a common language" :-) -- Stuart On 4 Sep 2009 at 19:55, William Hindman wrote: > ...I kept looking for that bloody icon with the "rubber" on it but all I > could find was one with an eraser ...shame, that ...I can think of more than > a few uses for an icon with a "rubber" on it, eh :) > > William > > -------------------------------------------------- > From: "Stuart McLachlan" <stuart at lexacorp.com.pg> > Sent: Friday, September 04, 2009 7:36 PM > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > 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