John Skolits
askolits at nni.com
Wed Aug 29 23:46:03 CDT 2007
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