Pop Up Calendar in Report

[Guest]

I would like to have a pop up calendar or date picker whichever in a report.
My report is based on query, which I now use the between start date and end
date
However the date has to be typed in, along with the / between the numbers
this is causing mistakes, I thought if I could put a pop up calendar it would
help eleminate some mistakes. I do have a calendar which works, but I can't
figgure out how to put it in the query or report.
Thanks for any help
Roger

 

[Larry Linson]

Reports, even in preview, are not interactive, as Forms are. Put your popup
into a Form where you collect the information, and from which you run the
Report.

Larry Linson
Microsoft Access MVP

 

[Guest]

Thanks Larry
I'll try that

Reports, even in preview, are not interactive, as Forms are. Put your popup
into a Form where you collect the information, and from which you run the
Report.

Larry Linson
Microsoft Access MVP

 

[Arvin Meyer [MVP]]

In addition to Larry's comment, have a look at the popup calendars at:

http://www.datastrat.com/Download/Calendar2K.zip

or:

http://www.mvps.org/access/forms/frm0050.htm

or:

http://www.lebans.com/monthcalendar.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks Larry
I have put the calendar in my form, but i can't
get my report to use the form as a record source.
What am I doing wrong?
It only gives me querry or table.
Query is where I have the between start and end dates
Thanks for any help
Roger

 

[Larry Linson]

Thanks Larry
I have put the calendar in my form, but i can't
get my report to use the form as a record source.
What am I doing wrong?
It only gives me querry or table.
Query is where I have the between start and end dates
Thanks for any help
Roger

I apologize if I left the impression that you could use a Form as
RecordSource for a Report -- you can't, and it was not my intention to imply
that you could.

You collect those dates from the Text Boxes on the Form, and, in VBA code,
construct the WhereCondition clause of a DoCmd.OpenReport that you use to
open the report, or (a little more work, but more efficient) construct an
SQL statement that you pass to the Report for use as its RecordSource.

Larry Linson

 

[Guest]

Thanks Larry
I only wanted to be able to use the pop up calendar
when I opened a report, to be able to enter date requested for report
I probably mistated what I was trying to do.
The way I now have it, when I open a report, I have to enter
date I want by typing it in. Like this 11/18/05 They have to use the
slash mark between the numbers I only have this with reports & query
It is the criteria in my querry, is there any way to get the pop up there?
I thought a pop up calender would
eleminate errors. Any Ideas
Thanks for the help
Roger