Using start and end date criteria in a form

G

Guest

I currently have a field called Award Date in a query. I'd like to generate
a form prompt that asks the user for a start and end date; the form will
bring up all projects whose award dates fall between those dates.

I also have a report based on that query. Additionally, I'd like for the
user to click a command button to print the report that is produced based on
those dates.

All advise is prematurely appreciated.
 
V

Van T. Dinh

Create a Form "frmParameters" with 2 TextBoxes (for StartDate and EndDate)
and 3 CommandButtons (for opening Form, previewing Report and printing
Report).

In the Query, use the references to the 2 TextBoxes as the Parameters for
your selection criteria.

When the user wants to open the Form or Preview / Print the Report, your
code opens the Form "frmParameter" first for the user to enter the dates.

In the code for the CommandButtons, you should check that the user enter
valid dates before attempting the actual processing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with date criteria in Query 2
Creating a form 4
Parameter window askes for start date and end date 3
start and end dates in a query 2
Crosstab Query and Date Parameters 10
Calculate number of days between a start date and an end date 2
Start date and End date 4
Using Date parameters in select queries Access 2003 5

Top