great. Thank You John.
I will get back to my other issue with the colors on the other database on Wednesday.
Jim Wagner
On Tuesday, July 15, 2014 4:31 PM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Jim-
The more efficient way to do it is:
Me.Filter = "[Crew 1] = 0"
Me.FilterOn = True
To remove the filter, just do:
Me.FilterOn = False
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
(Paris, France)
On Jul 15, 2014, at 7:22 PM, Jim Wagner luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I have 3 buttons that filters a form based on 3 different criteria. I am using syntax as follows
DoCmd.ApplyFilter , "[Crew 1] = 0"
The users are technically challenged and will not see the Toggle filter button on the ribbon. How would I code an applyfilter button to toggle the filter off?
Thank You
Jim Wagner
__._,_.___
Posted by: Jim Wagner <luvmymelody@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Yahoo Groups
Control your view and sort preferences per Yahoo Group
You can now control your default Sort & View Preferences for Conversations, Photos and Files in the membership settings page.
.
__,_._,___
Tidak ada komentar:
Posting Komentar