Keyboard Shortcuts.....

[WhizzkidWallace]

Hi there,

I am using access a lot these days, and try to use keyboard shortcuts where possible (leave that mouse alone....), so does anyone know a way to get to the FILTER menu when viewing a form using the keyboard...i.e without having to right click on the field and then click in the FILTER FOR box.

In more detail, the form looks like a table, and I may want to filter on one field, then sub-filter on another etc.....

Then also a shortcut to REMOVE the filters would be good too.....

If I have to create buttons on the form with code behind that ok.

Thanks

 

[ghudson]

You should create your own command buttons with custom VBA to perform your functions. Command buttons allow you to use an "event" which allows you to customize the action. The users should not be allowed to access the main menus and tools bars. Disabling the right-click option will also prevent the user from accessing the design view of your db objects. Search around for there is code and samples posted on how to disable that stuff.

 

[WhizzkidWallace]

Thanks. I have created buttons on my forms to do most things, and I agree that users should not have access (pardon the pun) to the built in menus etc. The only reason I have not disabled the right click menu is the users need to filter, so I could use some help with the necessary code to put behind a couple of buttons to 1) Add/Apply a filter, and 2) Clear a filter.

Thanks.

 

[WhizzkidWallace]

This would be the ideal for me....

The user can click into any active field on the form, and then by clicking a single FILTER button, an input box appears, they type something in, and when they press enter or click ok, the form uses that input to filter on the currently selected field. This can be repeated to filter further on the same or other fields. Another button on the form removes all filters, but the form stays and can be filtered again if required.

I have some ideas, but lack the knowledge to do it.

Any help would be great.

 

[ghudson]

Search around for there are lots of posts discussing how to use a custom filter button.