ACCESS FEED: Re: RE: [MS_AccessPros] Filter

Selasa, 26 Januari 2016

Re: RE: [MS_AccessPros] Filter

Graham-

Thanks a lot.

Best Regards,

Kevin

From: 'Graham Mandeno' graham@mandeno.com [MS_Access_Professionals]
Date: 2016-01-26 18:39
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Filter

Hi Kevin
To me this looks like an ORDER BY clause rather than a WHERE (filter) clause.
If so, it should be:
Me.OrderBy = "GroupCode ASC"
Me.OrderByOn = True
Best wishes,
Graham

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, 26 January 2016 22:50
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Filter

Kevin-

The Filter property must look like what you would put after the WHERE keyword in SQL. Which field do you want to filter? I suspect you meant to do something like:

Me.Filter = "[MyField] = 'GroupCode ASC'"

or

Me.Filter = "[GroupCode] = 'ASC'"

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Jan 26, 2016, at 10:35 AM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Dear All,
The filter I use doesn't work. Please help. Thanks in advance.
Me.Filter = "GroupCode ASC"
Me.FilterOn = True

Best Regards,
Kevin