Query Build

[ryne23]

Is it possible to build a query using a form with check boxes? What I would like to do is if the field on the form is checked then it is included in the query. If it is not checked it ignored and excluded from the query.

Thanks
Mike

 

[dhookom]

There is a complete "applet" for similar functionality at Query By Form.

Users can select a field, set filtering, aggregate, sort, and a bunch of other stuff with little effort.

Duane
Hook'D on Access
MS Access MVP

 

[ryne23]

Thank you it looks like it is just what I needed.

 

[ryne23]

My users are crazy about it. Thanks for pointing me in the right direction.

Mike

 

[dhookom]

My users love it also. I include this applet in nearly every application I create. In some apps with a SQL Server backend, I have modified the applet to use pass-through queries which increases the performance.

Thanks for the feedback.

Duane
Hook'D on Access
MS Access MVP

 

[ryne23]

How did you modofy it. Sounds interesting. I am always looking for ways to increase spped in my databases?

 

[dhookom]

The mods for pass-through required setting the delimiters in the code that builds the SQL statement to single quotes rather than double quotes or # (dates). I then just changed the SQL property of a saved pass-through query (qsptMyQuery).

This required creating master queries/views in the SQL database.

Duane
Hook'D on Access
MS Access MVP

 

[ryne23]

Thank you, I will give it a try.