Fellow member Peter Weinrum developed a cool technique to provide custom Shortcut menus in Report View for an app running in Runtime. (He gives me some credit for helping with suggestions, but he built all the cool code.) You can see what his code does here:
Description:
Access Runtime strips away the default right click Shortcut Menu which is bloated and contains selections which are always deactivated such as Report Sorting.
I designed 3 custom Shortcut Menus in VBA which are toggled depending on which field or section the user right clicks. There is a shortcut Menu for Text, Numeric data and a Basic Shortcut menu for calculated fields and other sections that cannot be filtered.
At a certain point in the video, instead of removing filters using the command I use the Ctrl+Z shortcut.
The ShortCut menu's are fully customizable with a selection of hunderds of Access commands to choose from.
Special thanks to MVP John Viescas for assisting me in the development of this solution.
I designed 3 custom Shortcut Menus in VBA which are toggled depending on which field or section the user right clicks. There is a shortcut Menu for Text, Numeric data and a Basic Shortcut menu for calculated fields and other sections that cannot be filtered.
At a certain point in the video, instead of removing filters using the command I use the Ctrl+Z shortcut.
The ShortCut menu's are fully customizable with a selection of hunderds of Access commands to choose from.
Special thanks to MVP John Viescas for assisting me in the development of this solution.
Peter, would you be willing to share your code with the group?
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
__._,_.___
Posted by: John Viescas <johnv@msn.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar