ChrisO
Registered User.
- Local time
- Today, 10:20
- Joined
- Apr 30, 2003
- Messages
- 3,202
Shortcut Menu Bars.
This is a demo of how to create shortcut menu bars from table data.
Unlike the shortcuts on normal shortcut menu bars all the shortcuts in the demo are driven by VBA. This allows altering the normal behaviour of the shortcut or creating your own.
In this demo the shortcut menu bar is generated in the On Current even of a continious sub-form. The shortcut menu bar could also be generated in the On Open event but the On Current event would allow modifing the shortcuts on the fly depending on current data in the record.
The shortcut data in the table can be flagged as required or not on a Form by Form basis.
Some of the examples given are: -
Spell check.
Sort ascending.
Sort descending.
Filter by selection.
Remove filter.
Call a public function with control data.
Call a public function with the primary key.
Export the current Sort/Filter selection to Excel, Word, etc.
Call public functions.
Execute hyperlinks.
Basically what this means is that if we can write code to do something then that code can be called from a shortcut.
The attached demo, in Access 2003, has been tested with many regional settings and requires no references.
If you have any questions, please ask them in the appropriate forum.
Regards,
Chris.
This is a demo of how to create shortcut menu bars from table data.
Unlike the shortcuts on normal shortcut menu bars all the shortcuts in the demo are driven by VBA. This allows altering the normal behaviour of the shortcut or creating your own.
In this demo the shortcut menu bar is generated in the On Current even of a continious sub-form. The shortcut menu bar could also be generated in the On Open event but the On Current event would allow modifing the shortcuts on the fly depending on current data in the record.
The shortcut data in the table can be flagged as required or not on a Form by Form basis.
Some of the examples given are: -
Spell check.
Sort ascending.
Sort descending.
Filter by selection.
Remove filter.
Call a public function with control data.
Call a public function with the primary key.
Export the current Sort/Filter selection to Excel, Word, etc.
Call public functions.
Execute hyperlinks.
Basically what this means is that if we can write code to do something then that code can be called from a shortcut.
The attached demo, in Access 2003, has been tested with many regional settings and requires no references.
If you have any questions, please ask them in the appropriate forum.
Regards,
Chris.
