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

Welcome Guest ( Log In | 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
From: Maryland



The attached Zip file contains a demo of three ways that a form can be employed to create a dynamic query.

1) 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: 1921
 


--------------------
William
“We're run by the Pentagon, we're run by Madison Avenue, we're run by television, and as long as we accept those things and don't revolt we'll have to go along with the stream to the eventual avalanche"
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 29th July 2014 - 07:56 PM