Solved

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

Posted on 2012-03-19
4
363 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

810 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