Solved

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

Posted on 2014-03-04
3
252 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 119

Accepted Solution

by:
Rey Obrero 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

920 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

12 Experts available now in Live!

Get 1:1 Help Now