Charlotte Foust
charlotte.foust at gmail.com
Wed Dec 10 17:16:19 CST 2014
If you reload the report view with the passed option (in OpenArgs), the code should only need to run once, so if I understand what you're doing, you may need a me.requery in the report routine that sets the sort order. Charlotte On Wed, Dec 10, 2014 at 1:25 PM, Brad Marks <bradm at blackforestltd.com> wrote: > Susan, Bruce, Charlotte, > > Thanks for your assistance on this question. > > I now have a small Access 2007 report that has two buttons. One button > changes the SortOrder in the Report Group to Ascending and the second > button changes the SortOrder in the Report Group to Descending. (I use > "Report View") > > Here is the actual VBA code that I am using for these two report buttons. > > Me.GroupLevel(0).SortOrder = False ' Ascending > > Me.GroupLevel(0).SortOrder = True ' Descending > > > > This all works nicely, except for one thing. In order to see the affect > of either the Ascending button or the affect of the Descending button, I > need to execute the same line of code two times. > > Example - > > Me.GroupLevel(0).SortOrder = False ' Ascending > Me.GroupLevel(0).SortOrder = False ' Ascending > > > Things seem to always work nicely, when I do this, but I would like to > understand why it appears to take two executions of this code. > > Any ideas? > > Thanks, > Brad > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto: > accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins > Sent: Tuesday, December 09, 2014 5:16 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Change Order within Access 2007 Report Group > > I once added a toolbar to a report like this and used VBA to group the > report according to the user choice from the toolbar. It was easy -- I > thought maybe I'd written about it and looked for an online article, but > didn't find one. Might be something to write about. It would be easy to add > sort options to a custom group that opens with the report I would think. > > Susan H. > > On Tue, Dec 9, 2014 at 5:33 PM, Charlotte Foust <charlotte.foust at gmail.com > > > wrote: > > > The simplest way is to have two groups on the same values, one sorted > > one way and the second sorted the other. Then just show or hide the > > group depending on what the user wants. > > > > Charlotte > > > > On Tue, Dec 9, 2014 at 1:48 PM, Brad Marks <bradm at blackforestltd.com> > > wrote: > > > > > All, > > > > > > Is it possible to change the order in an Access report Group from > > > "with A on top" to "with Z on top" with VBA code? > > > > > > We currently have an Access 2007 report that our Accounting > > > Department uses daily. This report has one report "Group" on > > > Sales_Order_Number (Ascending). > > > > > > Recently it was requested that a second report be created with the > > > Sales_Order_Numbers in descending order. > > > > > > Instead of creating a second report, I would like to have a button > > > to change the Report's Group Order on the fly. Is this possible via > > > VBA > > code? > > > > > > We have several other reports where the sort order is changed on the > > > fly, but none of these have report Groups. > > > > > > Thanks, > > > Brad > > > > > > -- > > > 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 >