Solved

Allow user to select fields in a form (at runtime) to see in Access 2010

Posted on 2012-03-19
4
349 Views
Last Modified: 2012-03-20
Hi

I am using Microsoft Access 2010 with vba running in the background.

I will be using a continuous form to present the data to the user.  I would like for the user to choose what fields to view at runtime.  I have ideas on how to do this,  but I would like some considered opinions.

Thanks
0
Comment
Question by:peispud
4 Comments
 
LVL 15

Accepted Solution

by:
Simon Ball earned 250 total points
ID: 37736876
Listbox and select button.

listbox contains field names and multiselect mode on

when button pressed, use VBA to loop through listbox contents.  if selected, set field control to visible., if not, set field to invisible..
0
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 250 total points
ID: 37736878
At a simple level, you can set the visible property to No for controls you don't want to see but in a continuous form you will still see the gap where the field would appear if it were visible.

If you are able to use form datasheet view instead then you can set each columns 'hidden' property in the Form_Open event procedure ,like...

Me.Fieldname.ColumnHidden = True
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37738479
Do you really need a truly "Open Ended" system here...?

Most situations require 2 or 3 different combinations of fields, ...In this case you can simply create separate forms, and be done with this.

If this is a "Security" issue, then you will probably need something a lot stronger that simply "hiding" the Columns...
0
 
LVL 44

Expert Comment

by:GRayL
ID: 37738525
peispud:  This question is now over 8 hours old and  you have been asked a few questions - may I request your answers?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
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.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

910 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

19 Experts available now in Live!

Get 1:1 Help Now