Pick List Field chooser

[AndyJ]

I have created a database which has about 70 fields of information. I have created standard reports featuring the data that I think my customers will require. However, to enable my non-technical colleagues to be able to select which fields they would like to include in an ad-hoc report I have attempted to create a ‘pick-list’ whereby they select which fields they want in the report (see attachment for a picture).

Except, I can’t figure out how to do it! I’ve got a table with a list of all the fields on the left hand side of the form and I want the user to be able to select the fields by dragging (or double clicking) the chosen fields to the empty text box/list on the right hand side of the form.

I know it’s possible to do this because I saw it on an Access Database many years ago (which I no longer have access to sadly) but I have no idea how to do it.

Can anyone help??

 

[Mile-O]

I have created a database which has about 70 fields of information.

All in one table?

 

[AndyJ]

Yes, there's 70 fields in one table (I know that's not very efficient but I'm only an occassional Access Dabbler with limited ability!).

There are other tables too, I have created a table simply listing the 70 fields used in the main table, this is the data-source for my proposed pick-list.

Does that sound like the right thing to do?

 

[Mile-O]

Does that sound like the right thing to do?

Absolutely not.

To get any results, and especially long-lasting ones, you need to think about your design structure before you even get into such things as forms and reports.

Detail your database and what sort of things you store within it.

 

[AndyJ]

The database is to be used to store information regarding the development of projects within my organisation.

Basic information to be held is stuff like Project Name, Reference, Description, Impact, No. staff Affected, key dates, contact details, solution methods, costs etc.

I simply requested a list of required information from the eventual user and put it in a table (called Main Table). I have also created a few tables for the fields in the main table which require the user to select from a pre-determined list.

In terms of simply storing information and printing standard reports the database is functioning correctly.

However, I thought it would be useful to have a form which enabled the user to choose which of the fields they would like to have on their report. I naively thought it would be pretty straight forward - it would appear not.

Do you have any suggestions on how to use the fields selected in the list? Is there a way of getting Access to use the selected fields to produce prints.

As I said before, I am a relative novice at Access so please be gentle with me!

 

[amanco]

one of my to do list is to have a check box of what to include in a report. i would really appreciate help as well regarding this matter. Cheers