Rocky Smolin
rockysmolin at bchacc.com
Fri Sep 4 17:35:26 CDT 2009
SO when they select the sort option, what's the code behind the after update event of that combo box? Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert Sent: Friday, September 04, 2009 2:55 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] MS Access 2007 Subform Sort In Access 2007 (and with an .mde) they added a small "down Arrow" dropdown box for each field in form who's view is in datasheet. Among a bunch of filter options, you have sort options A-Z and Z-A. But epically failing, by not providing a way to remove a sort. Well at least they provided a way to remove a filter..;-) This feature is one of the main reason I have been developing in Access 2007... ;-) 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 5:19 PM 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