Results 1 to 6 of 6
  1. #1
    talktime is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    21

    filter by form and apply filter with Keyboard


    can we accomplish Filter by Form and Apply Filter command via keyboard, is there a shortcut key or any workaround for it???

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    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.

  3. #3
    talktime is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    21
    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.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    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.

  5. #5
    talktime is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    21
    i want these two command universal, mean i want to execute these command from different forms. not just one form.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Filter By Form and Apply Filter Buttons
    By JustLearning in forum Forms
    Replies: 13
    Last Post: 02-18-2015, 01:01 PM
  2. Apply Filter similar to Field Filter
    By DatabaseIntern in forum Forms
    Replies: 1
    Last Post: 06-11-2012, 05:42 PM
  3. How to filter dates using an apply filter code.
    By Jgreenfield in forum Reports
    Replies: 4
    Last Post: 11-15-2011, 01:38 PM
  4. Option button to apply filter
    By catguy in forum Programming
    Replies: 4
    Last Post: 06-23-2011, 12:10 PM
  5. Apply filter command
    By miziri in forum Forms
    Replies: 6
    Last Post: 01-21-2010, 02:22 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums