input box

T

Terry

I created a query to pull records based on dates. I then
added a button to my switchboard to run the query. I
would like to have a box pop up after the button is
pushed where I could enter a date range. I would like it
to have 2 input fields.One for the beginning date and one
for the end date. Can someone tell me how to do this?
Thanks in advance.
 
T

tina

open the query in design view. set the criteria for the date as follows:

Between [Enter Start Date] And [Enter End Date]

on the menu bar, click Query, Parameters. set one line for each parameter,
as
Parameter
[Enter Start Date]
Data Type
Date/Time
2nd line
Parameter
[Enter End Date]
Data Type
Date/Time

note that the Between...And... statement is "inclusive", i.e. Between July 1
2004 And July 15 2004 will include records dated July 1, and records dated
July 15.

having said all that, i'll add that personally i don't care for parameter
queries. i prefer to open a dialog box (a small form) with unbound controls
for entering the dates, and setting the query criteria to
Between Forms!DialogFormName!StartDateControlName And
Forms!DialogFormName!EndDateControlName
i find it easier to control/validate the dates entered by the user, from a
form.

hth
 
R

Rohn

Tina,
I would agree. I find that the end user has less troubles understanding the
prompt when it is form based (i.e. pop-up dialog box).

----------
Rohn Everson

open the query in design view. set the criteria for the date as follows:

Between [Enter Start Date] And [Enter End Date]

on the menu bar, click Query, Parameters. set one line for each parameter,
as
Parameter
[Enter Start Date]
Data Type
Date/Time
2nd line
Parameter
[Enter End Date]
Data Type
Date/Time

note that the Between...And... statement is "inclusive", i.e. Between July 1
2004 And July 15 2004 will include records dated July 1, and records dated
July 15.

having said all that, i'll add that personally i don't care for parameter
queries. i prefer to open a dialog box (a small form) with unbound controls
for entering the dates, and setting the query criteria to
Between Forms!DialogFormName!StartDateControlName And
Forms!DialogFormName!EndDateControlName
i find it easier to control/validate the dates entered by the user, from a
form.

hth
 
T

Terry

Thanks for the reply. I got the query to work using the
parameter query but was unable to make it work with a
dialog box. Once again, thanks for the replies.
-----Original Message-----
open the query in design view. set the criteria for the date as follows:

Between [Enter Start Date] And [Enter End Date]

on the menu bar, click Query, Parameters. set one line for each parameter,
as
Parameter
[Enter Start Date]
Data Type
Date/Time
2nd line
Parameter
[Enter End Date]
Data Type
Date/Time

note that the Between...And... statement is "inclusive", i.e. Between July 1
2004 And July 15 2004 will include records dated July 1, and records dated
July 15.

having said all that, i'll add that personally i don't care for parameter
queries. i prefer to open a dialog box (a small form) with unbound controls
for entering the dates, and setting the query criteria to
Between Forms!DialogFormName!StartDateControlName And
Forms!DialogFormName!EndDateControlName
i find it easier to control/validate the dates entered by the user, from a
form.

hth


I created a query to pull records based on dates. I then
added a button to my switchboard to run the query. I
would like to have a box pop up after the button is
pushed where I could enter a date range. I would like it
to have 2 input fields.One for the beginning date and one
for the end date. Can someone tell me how to do this?
Thanks in advance.
Click to expand...


.
Click to expand...
 
Top