Need a good Access Pop-Up date Control for dynamic reports

  • Thread starter Thread starter Matthew David
  • Start date Start date
M

Matthew David

I was just contracted for an Access project. The customer has a lot of data
that he wants to see in reports. The catch is that he wants to select a date
range from a start and end date and then a custom report to view the data.
First, are there any good examples of this out there and second which third
party date controls should I be looking to buy?

Thanks for all and any help,
 
I am new to Access development (I have done a lot of SQL 2000 and ASP.NET
development). Is there any good examples of using date controls to format
data in a report?

Thanks sooo much.

Matthew
 
Not sure I understand the question.

You want a report that looks like a clock or something?

The Format property of the text box on your report lets you specify how the
date should appear.
 
No, what I need is very simple. The Access database has been created with
the reports that I need. Each report is generated across a Start/End date
range. What I am looking to do is to create a Form where you can select from
the Calendar controls a Start and End date, the report from a drop down and
then a button which runs the report. My guess is that this has been done
before, but I would like to know where. I have no problem paying.

Matthew
 
Okay, David, if you open the Northwind sample database, and the form named
Sales Report Dialog, you will see an option group on the left, with command
buttons on the right for print or preview.

In form design view, you can see that the On Click property of these command
buttons is an Event Procedure that calls the routine named PrintReports.
That routine does a Select Case to open the right report.

The last item (Case3), does the OpenReport with a WhereCondition. That's how
you limit the report.

For an example of how to limit the report using controls for Start Date and
End Date, see:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html
It creates the WhereCondition for OpenReport, just like Northwind did.

HTH
 
Back
Top