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

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,

--
Matthew David
PH: 920.475.2972
FAX: 775.239.8171

Heaps of freebies out there.

This is about as simple as it gets, just an Access form:
http://allenbrowne.com/ser-51.html

This is a wrapper for the Microsoft Month calendar:
http://www.lebans.com/monthcalendar.htm

Here's a list of mo
http://www.granite.ab.ca/access/calendars.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Matthew David" wrote in message
...
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. I will check these out.
"Allen Browne" wrote in message
...
Heaps of freebies out there.

This is about as simple as it gets, just an Access form:
http://allenbrowne.com/ser-51.html

This is a wrapper for the Microsoft Month calendar:
http://www.lebans.com/monthcalendar.htm

Here's a list of mo
http://www.granite.ab.ca/access/calendars.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Matthew David" wrote in message
...
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?

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
"Allen Browne" wrote in message
...
Heaps of freebies out there.

This is about as simple as it gets, just an Access form:
http://allenbrowne.com/ser-51.html

This is a wrapper for the Microsoft Month calendar:
http://www.lebans.com/monthcalendar.htm

Here's a list of mo
http://www.granite.ab.ca/access/calendars.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Matthew David" wrote in message
...
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?

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Matthew David" wrote in message
...
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
"Allen Browne" wrote in message
...
Heaps of freebies out there.

This is about as simple as it gets, just an Access form:
http://allenbrowne.com/ser-51.html

This is a wrapper for the Microsoft Month calendar:
http://www.lebans.com/monthcalendar.htm

Here's a list of mo
http://www.granite.ab.ca/access/calendars.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Matthew David" wrote in message
...
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?

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
"Allen Browne" wrote in message
...
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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Matthew David" wrote in message
...
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
"Allen Browne" wrote in message
...
Heaps of freebies out there.

This is about as simple as it gets, just an Access form:
http://allenbrowne.com/ser-51.html

This is a wrapper for the Microsoft Month calendar:
http://www.lebans.com/monthcalendar.htm

Here's a list of mo
http://www.granite.ab.ca/access/calendars.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Matthew David" wrote in message
...
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?

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Matthew David" wrote in message
...
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
"Allen Browne" wrote in message
...
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.

"Matthew David" wrote in message
...
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
"Allen Browne" wrote in message
...
Heaps of freebies out there.

This is about as simple as it gets, just an Access form:
http://allenbrowne.com/ser-51.html

This is a wrapper for the Microsoft Month calendar:
http://www.lebans.com/monthcalendar.htm

Here's a list of mo
http://www.granite.ab.ca/access/calendars.htm

"Matthew David" wrote in message
...
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?

You are a life saver. I can not wait to dig through this.
"Allen Browne" wrote in message
...
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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Matthew David" wrote in message
...
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
"Allen Browne" wrote in message
...
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.

"Matthew David" wrote in message
...
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
"Allen Browne" wrote in message
...
Heaps of freebies out there.

This is about as simple as it gets, just an Access form:
http://allenbrowne.com/ser-51.html

This is a wrapper for the Microsoft Month calendar:
http://www.lebans.com/monthcalendar.htm

Here's a list of mo
http://www.granite.ab.ca/access/calendars.htm

"Matthew David" wrote in message
...
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?