Build Query

[Chris]

Hi

Is it possible to let the user build his owne Query by
using a form

Thanks

Chris

 

[Ken Snell]

Possible? If you mean, can a user specify the criterion and the fields to be
used, yes.

Easy? Not necessarily. You must use VBA code to build the query, and then to
run it.

Can you provide more details?

 

[---TeteDeMulle--]

Hi ken

Yes that what I mean to give the user the posibility to specify the criteria
by using a list box

thanks

 

[Duane Hookom]

There is a complete Query By Form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
solution is ready to import into your MDB. You then create a few "master"
queries with names like "<Employees>", "<Sales Details>", "<Project
Summary>",...
The applet saves all queries in a couple tables so users can modify and
re-run. Results are a couple clicks from sending to Print, CSV, Word Table,
Word Merge, Excel, Graph, HTML,...