Paramaters

[Mike]

Between [Expense Starting Date? (m/d/yyyy)?] And [Expenses Ending Date?
(m/d/yyyy)?]

This is my formula that i have in the criteria of my query
When running the report i have to enter Expense Starting Date 8/1/2006
and Expense Date 8/31/2006. This works, but is there a way to have a
calender to be able to pick my starting date and ending date.

Any help would be GREAT

 

[Allen Browne]

You need to use a form to do this. Queries can't pop up calendars.

Method 2 in this article describes how to put 2 text boxes on a form for the
dates:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

And this one gives you a simple little Access form that looks like a
calendar, and can be launched by a button beside each of the text boxes:
Popup calendar
at:
http://allenbrowne.com/ser-51.html

 

[Mike]

That works, For my forms but i need it to pull my reports.

You need to use a form to do this. Queries can't pop up calendars.

Method 2 in this article describes how to put 2 text boxes on a form for the
dates:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

And this one gives you a simple little Access form that looks like a
calendar, and can be launched by a button beside each of the text boxes:
Popup calendar
at:
http://allenbrowne.com/ser-51.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Between [Expense Starting Date? (m/d/yyyy)?] And [Expenses Ending Date?
(m/d/yyyy)?]

This is my formula that i have in the criteria of my query
When running the report i have to enter Expense Starting Date 8/1/2006
and Expense Date 8/31/2006. This works, but is there a way to have a
calender to be able to pick my starting date and ending date.

Any help would be GREAT

 

[Allen Browne]

Can't you use the technique to create the WhereCondition for OpenReport as
the first article describes?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

That works, For my forms but i need it to pull my reports.

You need to use a form to do this. Queries can't pop up calendars.

Method 2 in this article describes how to put 2 text boxes on a form for
the
dates:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

And this one gives you a simple little Access form that looks like a
calendar, and can be launched by a button beside each of the text boxes:
Popup calendar
at:
http://allenbrowne.com/ser-51.html

Between [Expense Starting Date? (m/d/yyyy)?] And [Expenses Ending Date?
(m/d/yyyy)?]

This is my formula that i have in the criteria of my query
When running the report i have to enter Expense Starting Date 8/1/2006
and Expense Date 8/31/2006. This works, but is there a way to have a
calender to be able to pick my starting date and ending date.

 

[Mike]

What I have is a form with all my reports on it. Is there a way to have a
calender to
pick my dates instead of typing them in

Can't you use the technique to create the WhereCondition for OpenReport as
the first article describes?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

That works, For my forms but i need it to pull my reports.

You need to use a form to do this. Queries can't pop up calendars.

Method 2 in this article describes how to put 2 text boxes on a form for
the
dates:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

And this one gives you a simple little Access form that looks like a
calendar, and can be launched by a button beside each of the text boxes:
Popup calendar
at:
http://allenbrowne.com/ser-51.html

Between [Expense Starting Date? (m/d/yyyy)?] And [Expenses Ending Date?
(m/d/yyyy)?]

This is my formula that i have in the criteria of my query
When running the report i have to enter Expense Starting Date 8/1/2006
and Expense Date 8/31/2006. This works, but is there a way to have a
calender to be able to pick my starting date and ending date.

 

[Allen Browne]

Yes. You can pop up a calendar form to choose the date instead of typing it
in.

Download the calendar from the suggested article.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

What I have is a form with all my reports on it. Is there a way to have a
calender to
pick my dates instead of typing them in

Can't you use the technique to create the WhereCondition for OpenReport
as
the first article describes?

That works, For my forms but i need it to pull my reports.

:

You need to use a form to do this. Queries can't pop up calendars.

Method 2 in this article describes how to put 2 text boxes on a form
for
the
dates:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

And this one gives you a simple little Access form that looks like a
calendar, and can be launched by a button beside each of the text
boxes:
Popup calendar
at:
http://allenbrowne.com/ser-51.html

Between [Expense Starting Date? (m/d/yyyy)?] And [Expenses Ending
Date?
(m/d/yyyy)?]

This is my formula that i have in the criteria of my query
When running the report i have to enter Expense Starting Date
8/1/2006
and Expense Date 8/31/2006. This works, but is there a way to have a
calender to be able to pick my starting date and ending date.