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

Automatically input date into a parameter in Access query

P: 2
I have three querries that I am trying to run from a macro instead of running them one at a time. Each query promts for a date when opened. I would like to be able to enter the date once for all three. I know there must be an easy way to do this, but I can not seem to find it.
Jan 21 '10 #1
Share this Question
Share on Google+
2 Replies


Delerna
Expert 100+
P: 1,134
One method is to bind the criteria of the field in each query to a textbox on a form. Enter the date in the textbox and then each query will open using that date. The drawback is that the form must be open.

Criteria
Forms!FormName.TextboxName


Another method would be a table that only ever has one record in it with a field for each parameter required.

Then you just join to the desired field in the parameters table in your queries, and arrange that the date parameter (in your case) gets updated before you open the queries


There must be a million and one ways, which is best?
It depends on your design requirements.
Jan 21 '10 #2

P: 2
I went the table route. That was tooooooo easy. Sometimes the easiest is the hardest thing to see. Thanks for the help.
Jan 22 '10 #3

Post your reply

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