ACCESS FEED: Re: Re: [MS_AccessPros] Filter

Selasa, 26 Januari 2016

Re: Re: [MS_AccessPros] Filter

John-

Thanks a lot.

Best Regards,

Kevin

From: John Viescas JohnV@msn.com [MS_Access_Professionals]
Date: 2016-01-26 17:49
To: MS_Access_Professionals
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