[AccessD] MS Access 2007 Subform Sort

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




More information about the AccessD mailing list