Build Query

  • Thread starter Thread starter Chris
  • Start date Start date
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?
 
Hi ken

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

thanks
 
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,...
 
Back
Top