[AccessD] MS Access 2007 Subform Sort

Stuart McLachlan stuart at lexacorp.com.pg
Fri Sep 4 19:59:12 CDT 2009


As GBS put it: "two countries separated by a common language"

:-)

-- 
Stuart

On 4 Sep 2009 at 19:55, William Hindman wrote:

> ...I kept looking for that bloody icon with the "rubber" on it but all I 
> could find was one with an eraser ...shame, that ...I can think of more than 
> a few uses for an icon with a "rubber" on it, eh :)
> 
> William
> 
> --------------------------------------------------
> From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
> Sent: Friday, September 04, 2009 7:36 PM
> To: "Access Developers discussion and problem solving" 
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] MS Access 2007 Subform Sort
> 
> > You need to use that bl**dy ribbon.
> >
> > On the left hand side of  the "Sort & Filter" group  are three icons
> > 1. AZ and a down arrow
> > 2. AZ and an up arrow
> > 3. AZ and a rubber.
> >
> > The tooltip for the third one is "Clear all sorts"
> >
> > -- 
> > Stuart
> >
> > On 4 Sep 2009 at 18:52, Robert wrote:
> >
> >> 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
> >>
> >>
> >> -- 
> >> 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