William Hindman
wdhindman at dejpolsystems.com
Fri Sep 4 18:55:49 CDT 2009
...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 >