PC Review


Reply
Thread Tools Rate Thread

Command Button To Remove Macro Filter

 
 
ITAnnaJones@gmail.com
Guest
Posts: n/a
 
      13th Dec 2006
I am using Access 2003 and I have seven command buttons that each run
ApplyFilter for a specific User ID. I notice that the buttons are not
working right. I need a command button to remove all of the filters
applied to the form to get this to work, I believe. Any help is really
appreciated. Thanks.

 
Reply With Quote
 
 
 
 
Van T. Dinh
Guest
Posts: n/a
 
      13th Dec 2006
The code you need for the CommandButton is:

DoCmd.RunCommand acCmdRemoveFilterSort

--
HTH
Van T. Dinh
MVP (Access)



<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am using Access 2003 and I have seven command buttons that each run
> ApplyFilter for a specific User ID. I notice that the buttons are not
> working right. I need a command button to remove all of the filters
> applied to the form to get this to work, I believe. Any help is really
> appreciated. Thanks.
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you remove a macro command button? =?Utf-8?B?RGF2ZSBSb3dl?= Microsoft Excel Misc 1 25th Jul 2007 04:16 AM
Command button in Filter =?Utf-8?B?SmFtZXM=?= Microsoft Access Form Coding 4 18th Nov 2004 02:30 AM
Command Button for Macro Filter does not Work =?Utf-8?B?VG9tbXkgS2Vlbnpl?= Microsoft Access Forms 0 21st Jul 2004 10:27 PM
Filter Command Button Sol Microsoft Access Forms 1 30th Dec 2003 04:06 AM
set a filter by command button david Microsoft Access Forms 5 2nd Oct 2003 11:51 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:48 PM.