Stuart McLachlan
stuart at lexacorp.com.pg
Thu Aug 30 00:59:44 CDT 2007
You need to set the OrderByOn property in Code. It's one of many Form properties that don't show on the Property Sheet. :-( On 30 Aug 2007 at 0:46, John Skolits wrote: > > OK, so I can get the "order by" info, but when I try to push that info into > the datasheet's OrderBy property, it doesn't seem to change the view. > After I set the property, I tried doing a Forms!frmName.refresh (or requery) > and the form doesn't change. > The info is in the property but it doesn't refresh. Is their a property of > the form that is something like the AllowOrderBy? > So, how can I get the form to refresh after I set the OrderBy value? > > > John Skolits > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Skolits > Sent: Wednesday, August 29, 2007 11:40 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Finding the sort order on a datasheet. > > Duh!!! > > Well, I hope no one else sees this question! > > John > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of pcs at azizaz.com > Sent: Wednesday, August 29, 2007 11:00 PM > To: Access Developers discussion and problemsolving > Subject: Re: [AccessD] Finding the sort order on a datasheet. > > Hi John, > What about > > Forms!frmName.OrderBy > > Regards > borge > > > ---- Original message ---- > >Date: Wed, 29 Aug 2007 22:38:21 -0400 > >From: "John Skolits" <askolits at nni.com> > >Subject: [AccessD] Finding the sort order on a datasheet. > >To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > > > > > >I have a form that is displayed as a datasheet. If I do > some filtering, I > >can get the filter by > >"Forms!frmName.filter" > > > >But, what if I sort descending or ascending on a field? Is > there anyway to > >get that info? Is there a property of the datasheet > like "DatasheetSort"? > > > >John Skolits > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >-- > >AccessD mailing list > >AccessD at databaseadvisors.com > >http://databaseadvisors.com/mailman/listinfo/accessd > >Website: http://www.databaseadvisors.com > > > >No virus found in this incoming message. > >Checked by AVG Free Edition. > >Version: 7.5.484 / Virus Database: 269.12.1/963 - Release > Date: 8/20/2007 > >5:44 PM > > > > > >-- > >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