can we accomplish Filter by Form and Apply Filter command via keyboard, is there a shortcut key or any workaround for it???
can we accomplish Filter by Form and Apply Filter command via keyboard, is there a shortcut key or any workaround for it???
I have never used Filter by Form so had to investigate. Might be able to create a button on form that when clicked would execute the filter toggle.
DoCmd.RunCommand acCmdToggleFilter
Not tested, let us know how that works out.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Actually i use both of these in Forms, i have to click Filter by Form button on toolbar then i enter some criteria in the form and Apply Filter command to accomplish my task, i want both of these to execute from keyboard, first Filter by Form then Apply Filter.
You have a custom button on form to run the Toggle command? You can shortcut key the button caption so that Alt+key will execute.
One button for
Docmd.RunCommand acCmdFilterByForm
Another button for
DoCmd.RunCommand acCmdToggleFilter
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
i want these two command universal, mean i want to execute these command from different forms. not just one form.
Maybe a customized ribbon.
Or key press event
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
http://www.databaselessons.com/funct...-shortcuts.php
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.