Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Code Archive _ Dynamic Query Examples

Posted by: dashiellx2000 Apr 25 2007, 08:22 PM

The attached Zip file contains a demo of three ways that a form can be employed to create a dynamic query.
) Using Combo Boxes to establish the criteria for the query
2) Using Multiple Multi-Select List Boxes to establish the criteria for the query
3) Using Text Boxes to establish date criteria for the query
A special thanks to Jerry Dennison who's http://www.utteraccess.com/forums/showflat.php?Cat=&Board=48&Number=414388&Zf=f48&Zw=multi%20select&Zg=0&Zl=a&Main=414388&Search=true&where=&Zu=&Zd=l&Zn=&Zt=13&Zs=a&Zy=#Post414388&Zp= example was the inspiration for the second example.
Within the Zip file are A97 and A2003 versions.
HTH.

 dynamicqueryexamples.zip ( 237.56K ): 2472
 

Posted by: dashiellx2000 Nov 14 2019, 02:36 PM

Updated attachment created in Access365

 DynamicQueryExamples_365.zip ( 126.85K ): 68