Solved

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

Posted on 2012-03-19
4
383 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

734 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