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

Query Design help for Parameter Query

P: n/a
Hey all,

I created a Query (in Design View) which asks the user for an "As Of
Date" which would
then display relevant data. I put [Please enter As of Date] in the
Criteria Row of the Query Design for the Date field. Is there anyway to
put in a default of today's date in the input box and allow the user to
change it to
whatever they want? Please let me know if this needs further
clarification. Thanks for all your help in advance.

I'm a newbie at this so if you can please give me step by step info, I
will be extremely grateful.

Thanks in advance!

Jan 17 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 16 Jan 2007 22:26:00 -0800, "Haas C" <ha*****@yahoo.comwrote:

The parameter query like you created is very limited, and does not
allow setting a default value.
So you create a Criteria form, with a textbox on it for the date, and
perhaps even a button to pop up a calendar (e.g. from
http://www.mvps.org/access/forms/frm0050.htm) and a button to launch
the report (the button wizard can help).
Then change your query criteria to:
Forms!MyCriteriaForm!MyTextbox
(with the proper form and textbox name, of course).

-Tom.

>Hey all,

I created a Query (in Design View) which asks the user for an "As Of
Date" which would
then display relevant data. I put [Please enter As of Date] in the
Criteria Row of the Query Design for the Date field. Is there anyway to
put in a default of today's date in the input box and allow the user to
change it to
whatever they want? Please let me know if this needs further
clarification. Thanks for all your help in advance.

I'm a newbie at this so if you can please give me step by step info, I
will be extremely grateful.

Thanks in advance!
Jan 17 '07 #2

P: n/a
Tom,

Thanks for your help on this. It does seem as if I need to create a
Criteria Form - I'm actually working on one now!

Thanks again!

Haas

Tom van Stiphout wrote:
On 16 Jan 2007 22:26:00 -0800, "Haas C" <ha*****@yahoo.comwrote:

The parameter query like you created is very limited, and does not
allow setting a default value.
So you create a Criteria form, with a textbox on it for the date, and
perhaps even a button to pop up a calendar (e.g. from
http://www.mvps.org/access/forms/frm0050.htm) and a button to launch
the report (the button wizard can help).
Then change your query criteria to:
Forms!MyCriteriaForm!MyTextbox
(with the proper form and textbox name, of course).

-Tom.

Hey all,

I created a Query (in Design View) which asks the user for an "As Of
Date" which would
then display relevant data. I put [Please enter As of Date] in the
Criteria Row of the Query Design for the Date field. Is there anyway to
put in a default of today's date in the input box and allow the user to
change it to
whatever they want? Please let me know if this needs further
clarification. Thanks for all your help in advance.

I'm a newbie at this so if you can please give me step by step info, I
will be extremely grateful.

Thanks in advance!
Jan 19 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.