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

Welcome to UtterAccess! Please ( Login   or   Register )

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


UtterAccess VIP
Posts: 9,839
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: 2454
 
Go to the top of the page
 
dashiellx2000
post Nov 14 2019, 02:36 PM
Post#2


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


Updated attachment created in Access365
Attached File(s)
Attached File  DynamicQueryExamples_365.zip ( 126.85K )Number of downloads: 37
 

--------------------
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
 


Custom Search


RSSSearch   Top   Lo-Fi    11th December 2019 - 10:47 PM