Select Fields for Query

[pcfriar8741]

Hi,

I am developing an Access Database in 2003 for timesheets. I have a form
that a user can enter the employee number and the dates they want to look up.
What I also want them to be able to do is select which fields they want to
view. For example if a user wants to see employee X's regular and vacation
hours in the past month i want them to be able to select regular and
vacation. Essentially I want the form to be able to hide/unhide certain
fields based on user input. I'm not really sure how to go about doing this so
any feedback would be great!

 

[Piet Linden]

Hi,

I am developing an Access Database in 2003 for timesheets. I have a form
that a user can enter the employee number and the dates they want to lookup.
What I also want them to be able to do is select which fields they want to
view. For example if a user wants to see employee X's regular and vacation
hours in the past month i want them to be able to select regular and
vacation. Essentially I want the form to be able to hide/unhide certain
fields based on user input. I'm not really sure how to go about doing this so
any feedback would be great!

So you want to essentially replace the QBE grid? About the closest
you could get is to create a query with all the fields you want, then
use a multi-select listbox to get the column names from the query so
that the user can choose... then you would have to open the form in
design mode (but hide it from the user) and make the fields you don't
want the user to see not Visible. Either that, or if the sets of
fields are consistent, create a single form for each one... Definitely
a case where a web/HTML interface would be much easier to do...

 

[Duane Hookom]

There is a query-by-form "applet" available at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=12. This
provides the functionality you might need.