Results 1 to 3 of 3
  1. #1
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    Location
    North Carolina
    Posts
    155

    filtering a report via Calendar


    Have a reporting form that has several different options (backed by queries). I want to allow the user to choose date ranges for the reports to run by. I want to use the Calendar Control 11.0 to do so. My goal is to have them click a button to generate a report and when they click it, a calendar loads with the option to select a date range then it loads the report.

    There are about 20 different reports.
    Using 4-5 Queries.


    Is this possible?

    Thanks,

    J.

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    yes. it is just that in 03 you need to load a calendar activex component...while in 07 and beyond it is an embedded feature. as you are an advanced beginner I trust you will be able to google this topic to get the details of the component...

    hope this helps.

  3. #3
    Access_Blaster is offline User
    Windows XP Access 2010 32bit
    Join Date
    May 2010
    Posts
    339
    What happens if your user dosen't have "Calendar Control 11.0" loaded on his/her computer? Your code could open up with a nasty error message.
    Here is a Non ActiveX calendar control. You can use two unbound text boxes to find the between dates. See sample picture.



    Richard

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Report Filtering..
    By banjo1t in forum Reports
    Replies: 1
    Last Post: 01-24-2011, 06:56 AM
  2. Calendar Report
    By alison.justice in forum Reports
    Replies: 1
    Last Post: 06-11-2010, 04:25 PM
  3. Report Filtering
    By HM1 in forum Reports
    Replies: 2
    Last Post: 07-06-2009, 06:06 AM
  4. Filtering my report
    By ldarley in forum Reports
    Replies: 1
    Last Post: 09-05-2008, 09:14 AM
  5. Create a calendar report?
    By valkyry in forum Reports
    Replies: 0
    Last Post: 09-14-2006, 11:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums