Rocky Smolin
rockysmolin at bchacc.com
Fri Sep 4 17:21:10 CDT 2009
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