Filtering Keys

[Mary Fetsch]

Does anyone know if there are keyboard shortcuts in Access 2007 for the
"Filter By Form", "Filter", and sort "Ascending" buttons on the "Sort &
Filter" ribbon? Thanks!

Mary Fetsch

 

[Tom van Stiphout]

On Mon, 12 Nov 2007 12:59:00 -0800, Mary Fetsch

Nothing built in afaik, but it's easy to create your own. Create a new
macro, set MacroName={F12}, Action=RunCommand, Arguments=FilterByForm
Save this macro with name "AutoKeys"
Open your form, and click F12 to go in FilterByForm mode.

Of course you can use any key stroke / combination you like, and you
can have several macros in AutoKeys.

-Tom.

 

[Mary Fetsch]

Thanks a lot!

On Mon, 12 Nov 2007 12:59:00 -0800, Mary Fetsch

Nothing built in afaik, but it's easy to create your own. Create a new
macro, set MacroName={F12}, Action=RunCommand, Arguments=FilterByForm
Save this macro with name "AutoKeys"
Open your form, and click F12 to go in FilterByForm mode.

Of course you can use any key stroke / combination you like, and you
can have several macros in AutoKeys.

-Tom.

 

[banty]

Does anyone know if there are keyboard shortcuts in Access 2007 for the
"Filter By Form", "Filter", and sort "Ascending" buttons on the "Sort &
Filter" ribbon? Thanks!

Mary Fetsch

 

[Marsha]

If you hold down the Alt key, shortcut letters magically appear next to the
screen item they control. Filter by Form is Alt h f v f.