UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

 
   Reply to this topicStart new topic
> Dynamic Query Examples    
 
   
dashiellx2000
post Apr 25 2007, 08:22 PM
Post#1


UtterAccess VIP
Posts: 9,721
Joined: 11-March 05
From: Maryland


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 Creating a Query that uses a Multi-select Listbox as Criteria example was the inspiration for the second example.
Within the Zip file are A97 and A2003 versions.
HTH.
Attached File(s)
Attached File  dynamicqueryexamples.zip ( 237.56K )Number of downloads: 2059
 
Go to the top of the page
 


RSSSearch   Top   Lo-Fi    2nd July 2015 - 12:16 AM