Access:make filter in VB

A

ANSWER

Hi,

I want to make button who has on click event VB function "filter by
selection" and "remove filter by selection".

How can I do this
 
V

Van T. Dinh

For "Filter By Selection":

DoCmd.RunCommand acCmdFilterBySelection

For "Remove Filter"

DoCmd.RunCommand acCmdRemoveFilterSort
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting and filtering text 0
Link a text box based on drop down box with four options MS Word 365 0
Filtering data from a non-continuous list 3
Open form in "Filter By Form" mode 1
Place picture in Excel cell 0
VB Macro for Pivot Filter Function 0
Program buttons to create a word document 0
QAT disappears during filter-by-form 1

Top