By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,245 Members | 884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,245 IT Pros & Developers. It's quick & easy.

Make "Apply Filter" button in a form stay active when in filter mode

P: 5
Re: Filter By From, Apply Filter, Remove Filter Buttons in a Form.
--------------------------------------------------------------------------------

[quote=mattscho]Hi All, Trying to create a set of 3 buttons in a form that have the same effect as the "Filter by Form", "Apply Filter" and "Remove Filter" Buttons on the access toolbar. Help would be muchly appreciated. Cheers.[quote]

In the Click() Event of 3 Command Buttons, place the following code:
Code: ( vb )
'Filter by Form
DoCmd.RunCommand acCmdFilterByForm



Code: ( vb )
'Apply Filter
DoCmd.RunCommand acCmdApplyFilterSort



Code: ( vb )
'Remove Filter
DoCmd.RunCommand acCmdRemoveFilterSort


Hi, Does anyone know how to make the "Apply Filter" button stay active while in filter mode in a form. Cheers
Aug 17 '07 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
[quote=mattscho]Re: Filter By From, Apply Filter, Remove Filter Buttons in a Form.
--------------------------------------------------------------------------------

[quote=mattscho]Hi All, Trying to create a set of 3 buttons in a form that have the same effect as the "Filter by Form", "Apply Filter" and "Remove Filter" Buttons on the access toolbar. Help would be muchly appreciated. Cheers.

In the Click() Event of 3 Command Buttons, place the following code:
Code: ( vb )
'Filter by Form
DoCmd.RunCommand acCmdFilterByForm



Code: ( vb )
'Apply Filter
DoCmd.RunCommand acCmdApplyFilterSort



Code: ( vb )
'Remove Filter
DoCmd.RunCommand acCmdRemoveFilterSort


Hi, Does anyone know how to make the "Apply Filter" button stay active while in filter mode in a form. Cheers

See this link for code samples of functions built around these commands. Click the applicable hyperlink on the link below to go to the actual code. It takes more then one line of code to make each function emulate the functionality available from the toolbar.

http://home.clara.net/tkwickenden/code/codingf.htm
Aug 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.