[AccessD] MS Access 2007 Subform Sort

Robert robert at servicexp.com
Fri Sep 4 17:52:58 CDT 2009


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





More information about the AccessD mailing list