?
Solved

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

Posted on 2014-03-04
3
Medium Priority
?
266 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 1500 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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Implementing simple internal controls in the Microsoft Access application.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses
Course of the Month7 days, 2 hours left to enroll

593 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