Filtering Keys

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Thanks a lot!

Tom van Stiphout said:
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.
Click to expand...
 
Mary Fetsch said:
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
Click to expand...
 
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.
 
Back
Top