Show-Hide-Export to Excel

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)

Nifty Access YouTube Thumb Nail
Play Video

… …

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)

Nifty Access YouTube Thumb Nail
Play Video

… …

More Useful Stuff HERE:-

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Do you need a hand in the right direction?

You are in the right place.