Selecting Fields from Table for Query

[shuffine@hcreit.com]

I am looking for a way to generate a list of all fields within a table, have the end-user select which fields he/she wants to include, and then run the query. I am trying to create this within a form for a nice, easy to use GUI. Has anyone ever done this - and has examples? or can point me in the right direction to find the solution?

I really appreciate it. I am using Access 2010 on Windows. The fields I need them to select from are in one table, however there are many lookup (tblkp) tables related.

Thank you!

 

[JHB]

I am looking for a way to generate a list of all fields within a table, have the end-user select which fields he/she wants to include, and then run the query. I am trying to create this within a form for a nice, easy to use GUI. Has anyone ever done this - and has examples? or can point me in the right direction to find the solution?

You need some code (a For Each loop) to get all the fields name of the table, put them in a temporary table and include a "Yes/No" field.
Use continuous form (bound to the temporary table) where you select which fields you want in the query.
Then some code where you create the query string for the fields you have selected. And then run the query.

 

[spikepl]

You need some code (a For Each loop) to get all the fields name of the table

Not really. A listbox can by itself read the field names of a table. http://msgroups.net/microsoft.public.access.formscoding/populating-list-box-with/18846