Date Range on form

[Shannan C via AccessMonster.com]

How do I allow the user to input a date range into existing text boxes on a
form?

I don't want a query to be the source of a parameter prompt message box.

I know this is simple. Help!!!

Thanks,

Shannan Casteel

 

[Guest]

Just create an unbound text box and put the prompt in the label.

How will it be used? If you want it to be the criteria for a query then you
will need an action either code or macro to requery.

If your purpose is to pass the information entered to the display then do
this.
In design view grid of the query put your prompt like --
Between [Enter first date] and [Enter last date]
Then in blank column of the FIELD row of the grid type --
First Date: [Enter first date]
and in the next column --
Last Date: [Enter last date]

NOTE -- I always copy and paste the criteria to the FIELD row so there is NO
typos.

 

[David Lloyd]

Shannan:

The following KB article may be a good reference.

http://support.microsoft.com/kb/304428/EN-US/

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


How do I allow the user to input a date range into existing text boxes on a
form?

I don't want a query to be the source of a parameter prompt message box.

I know this is simple. Help!!!

Thanks,

Shannan Casteel

 

[Shannan C via AccessMonster.com]

I want to be able to insert a date range into 2 text boxes and have that date
range be used as criteria for a graph that is based on a query. I do not
want Access' parameter value prompt box to appear and ask me for this date
range after I have already entered it on the form. How do I do this?

Shannan

 

[Shannan C via AccessMonster.com]

I am no good with SQL.

I want to be able to insert a date range into 2 text boxes and have that date
range be used as criteria for a graph that is based on a query. I do not
want Access' parameter value prompt box to appear and ask me for this date
range after I have already entered it on the form. How do I do this?

Shannan

Shannan:

[quoted text clipped - 12 lines]

Shannan Casteel