Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Pop Up Calendar in Report

Discussion in 'Information Technology' started by XeniaEagle, Nov 18, 2005.

  1. XeniaEagle

    XeniaEagle
    Expand Collapse
    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
     
  2. Loading...

    Similar Threads Forum Date
    Sikhs Declining As A Percentage Of India's Population Hard Talk Apr 18, 2016
    Christianity How Pope Francis made me better appreciate my Sikh faith (COMMENTARY) Interfaith Dialogues Sep 27, 2015
    Declining Sikh population percentage in Punjab Sikh Sikhi Sikhism Aug 26, 2015
    Christianity Pope Francis Dines in the Vatican Cafeteria, Denounces the Mafia in Naples Interfaith Dialogues Jul 27, 2014
    Christianity Pope Francis admits reveals Bible metaphors - in agreement with Sikhi! Interfaith Dialogues Jan 3, 2014

  3. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    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" <XeniaEagle@discussions.microsoft.com> 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. XeniaEagle

    XeniaEagle
    Expand Collapse
    Guest

    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.
    >
    > Larry Linson
    > Microsoft Access MVP
    >
    > "XeniaEagle" <XeniaEagle@discussions.microsoft.com> 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. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    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

    "XeniaEagle" <XeniaEagle@discussions.microsoft.com> 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
     
  6. XeniaEagle

    XeniaEagle
    Expand Collapse
    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" 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" <XeniaEagle@discussions.microsoft.com> 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

    >
    >
    >
     
  7. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "XeniaEagle" <XeniaEagle@discussions.microsoft.com> 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
    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
     
  8. XeniaEagle

    XeniaEagle
    Expand Collapse
    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

    "Larry Linson" wrote:

    >
    > "XeniaEagle" <XeniaEagle@discussions.microsoft.com> 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
    > 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
    >
    >
    >
     

Share This Page