Charlotte Foust
charlotte.foust at gmail.com
Thu Dec 11 15:47:25 CST 2014
What event are you running that code in? Charlotte On Thu, Dec 11, 2014 at 1:33 PM, Brad Marks <bradm at blackforestltd.com> wrote: > > Charlotte, > > Thanks for the help. > > I tried adding the "me.requery" command but this change did not make a > difference. > > If "Me.GroupLevel(0).SortOrder = False" is executed one time, the sort > order is not changed > > If this command is executed two times, the sort order is changed. > > I have run many tests and these results are always consistent. > > I don't have a problem with executing the command twice. > > I am curious as to why this is happening, however. > > Thanks, > Brad > > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto: > accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust > Sent: Wednesday, December 10, 2014 5:16 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Change Order within Access 2007 Report Group - > Thanks! Plus Bonus Puzzler > > 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 > > > -- > 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 >