Solved

Access 2010: Create code to automatically hide columns in a Datasheet View in Access

Posted on 2014-03-04
3
254 Views
Last Modified: 2014-09-16
We have an Access Application where we are using a Datasheet Form for managing a schedule.  There are quite a few columns, and we do have the functionality on the form for the User to show and hide columns.

Is there a way to build code so that when the user selects a button that the columns and rows are hidden and filter to create a view that is repeatable?
0
Comment
Question by:btgtech
  • 2
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39903884
0
 

Author Comment

by:btgtech
ID: 39910341
Rey -

Can you explain a little more about how the code in the example knows which column to hide?
0
 

Author Comment

by:btgtech
ID: 39943492
I would really like to understand how the code in the example knows which column to hide?

Is there a limit to the number of columns that it will hide?
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now