Pop Up Calendar in Report

#1 (**permalink**) 18-Nov-2005, 14:00 PM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7705-pop-up-calendar-in-report.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7705
figgure out how to put it in the query or report.
Thanks for any help
Roger

*

#2 (**permalink**) 18-Nov-2005, 14:00 PM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7705
Report.

Larry Linson
Microsoft Access MVP

"XeniaEagle" wrote in message
news:657D74B0-7D87-477C-9F43-51792680450C@microsoft.com...
>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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7705
> 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

#3 (**permalink**) 18-Nov-2005, 14:00 PM

Thanks Larry
I'll try that

"Larry Linson" wrote:

> 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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7705
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7705
>
> Larry Linson
> Microsoft Access MVP
>
> "XeniaEagle" wrote in message
> news:657D74B0-7D87-477C-9F43-51792680450C@microsoft.com...
> >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
>
>
>

#4 (**permalink**) 19-Nov-2005, 21:59 PM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7705
--
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7705
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

"XeniaEagle" wrote in message
news:657D74B0-7D87-477C-9F43-51792680450C@microsoft.com...
> 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

#5 (**permalink**) 19-Nov-2005, 22:00 PM

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" wrote:

> 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
>
> "XeniaEagle" wrote in message
> news:657D74B0-7D87-477C-9F43-51792680450C@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7705
> >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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7705
> > 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
>
>
>

#6 (**permalink**) 19-Nov-2005, 22:00 PM

"XeniaEagle" wrote in message
news:B4A07772-8F2B-489A-B21A-F83F1A328C37@microsoft.com...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7705
> Roger

I apologize if I left the impression that you could use a Form as
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7705
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

#7 (**permalink**) 19-Nov-2005, 22:00 PM

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7705
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

"Larry Linson" wrote:

>
> "XeniaEagle" wrote in message
> news:B4A07772-8F2B-489A-B21A-F83F1A328C37@microsoft.com...
> > 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7705
> 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
>
>
>