Show/Hide & Export to Excel
What started out as an answer to a question on Expert Exchange, took on a life of its own and became a pop-up form which allows you to select the columns you want to display in a datasheet. Now, this is not at all a groundbreaking technology! It’s actually already available, you can select which columns are displayed quite easily from your datasheet. However, this popup form is somewhat easier to use, but nothing really to write home about! Then I realised by combining it with this code from BTAB Development:-
Code Snippets → Export A Table Or Query To Excel
https://btabdevelopment.com/export-a-table-or-query-to-excel/
I would be able to easily export Selected Columns and Rows to Excel!
Now that was something worth having! Hence "A New Product"
See it Working - Show/Hide - Export
Show/Hide Columns AND Export to EXCEL
Video 1 (1:26)
This is a demonstration of the Show/Hide and Export to Excel drop-in component working.
Video 1 (1:26)
… …
Show/Hide Column & Export to Excel - SETUP
Show/Hide Column & Export to Excel - SETUP
Video 2 (06:42)
In this video I demonstrate how easy it is to add this drop-in component into your MS Access Database. Establish yourself as the “Go To” person in your organisation for database improvements! Nifty Access Drop in “Nifty Components” will quickly elevate you to “Power User Level!”
Video 2 (06:42)
… …
