[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