By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,160 Members | 981 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,160 IT Pros & Developers. It's quick & easy.

*Help Needed* Start Date & End Date to run multiple queries...

matrekz42
P: 37
Hello,

I currently have a database which consists of about 100 queries. I want to create a button in a form that will run all 100 queries, but at the same time the user can pick the date range, by entering the dates. ie: textStartDate - textEndDate, in a form. This would change the date range on all the queries. What should I do? Thanks in advance.
Sep 4 '07 #1
Share this Question
Share on Google+
4 Replies


Rabbit
Expert Mod 10K+
P: 12,392
Have the queries use the date specified on the form.
Sep 4 '07 #2

matrekz42
P: 37
Hi, Thank you for your response, is that done with an expression? Or through VB?
Sep 5 '07 #3

Rabbit
Expert Mod 10K+
P: 12,392
No, where ever your query needs to use [Start Date] use [Forms]![FormName]![txtStartDate] instead.
Sep 5 '07 #4

matrekz42
P: 37
Oh perfect, Got it. Thanks!
Sep 5 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.