Results 1 to 11 of 11
  1. #1
    bobfin is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2010
    Location
    https://t.me/pump_upp
    Posts
    56

    Calendar to and From Dates

    Hi I am new to Access. I have 2010. I inherited a 97 database which I converted to access 2010. All works fine.



    There are several reports that require date ranges (begin dale & end Date). Currently they user has to enter them in manually. I would like to set up a pop up calendar for each.

    Can someone point me in the right direction.


    thanks,

    Bob

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    yes - be sure to invest in an Access2010 text book as inevitably you will have many other questions come along.

    Look at the table/field property and look at the form/field property. In both places there is a property "Show Date Picker" and this must be set to 'For Dates'.

    In addition - make sure there is no mask set up for the field. If there is a mask then that overrides the calendar option. Just delete it.

    This was a welcome addition in the Access07 version as a standard feature so that one did not have to manually add ActiveX components which was the approach preceeding 07....

    hope this helps.

  3. #3
    bobfin is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2010
    Location
    https://t.me/pump_upp
    Posts
    56

    Calender to and From Dates

    The date picker works fine in the forms. Where I need it to appear is in the query? When the report is called it brings up the date field called "Date Occurred" Start Date I need the Calendar to appear here. Then after that data is entered the end date pops up and I need a calendar there. The quey code is the following

    Between [Start date] And [End date]



    Can't seem to figure out how to change from manual enter to the pop up calender.

    bob

  4. #4
    Rawb is offline Expert
    Windows XP Access 2000
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    Make a Form that asks for these two dates. Then the Form can pass them on to the Query.

    That should let you use your Picker!

  5. #5
    bobfin is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2010
    Location
    https://t.me/pump_upp
    Posts
    56

    Date Range on Form

    Ok how do I make a date range on a form and do I call a query or the report?

    Thanks,

    Bob

  6. #6
    Join Date
    May 2010
    Posts
    339
    Hi Bob,

    Here is a very simple DB where you can see how the Form, Query and report work together. Download the sample to your desktop. Use the calendar to insert a valid date i.e. between 8/1/2010 and 8/4/2010. There are only 3 records but you can use different combinations.

    hth

    Richard

  7. #7
    bobfin is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2010
    Location
    https://t.me/pump_upp
    Posts
    56
    Thanks a lot. Looks pretty straight forward.
    I just will have to adapt it to about 30 reports.
    Anyways use 1 form for 30 reports?

    Bob

  8. #8
    Join Date
    May 2010
    Posts
    339
    Depends, if your talking about reports that you want use a date picker for then yes. You could have a button to Calculate Averages or whatever.

    Richard

  9. #9
    bobfin is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2010
    Location
    https://t.me/pump_upp
    Posts
    56
    Yes I have about 30 reports that recurrently require to hand enter the dates.
    So is it possible to hardcore each report to use just date form.

    Bob

  10. #10
    Join Date
    May 2010
    Posts
    339
    Quote Originally Posted by bobfin View Post
    Yes I have about 30 reports that recurrently require to hand enter the dates.
    So is it possible to hardcore each report to use just date form.

    Bob
    Bob, if you have 30 individual reports then you probably have a design issue. Going back to my simple database: It would work something like this. You would have a form to input data, another form to act as a date picker, one query and one report. Lets say you have a thousand records, but 30 different clients or 30 different dates. Your solution is sorting and grouping within your report. Remember the query is doing most the work, the report is based on the results of the query. Your report CAN sort and group on your date field or client names or combinations or whatever. In Access lots of routines are done on the fly, instead of hard coding.

    Care to post your Database in Access 2000 format? minus the data.

    hth
    Richard

  11. #11
    bobfin is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2010
    Location
    https://t.me/pump_upp
    Posts
    56
    I tried to save it 2000 format but it will not let me. Says the features I used
    in this version will not convert.

    I inherit this database. My first thought was to re-write.

    I tried applying your form to a report, it did not work. The report is pulling from 2 different tables causing problems

    Bob

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

Similar Threads

  1. Event Calendar Help
    By Nosaj08 in forum Forms
    Replies: 9
    Last Post: 06-11-2010, 11:19 AM
  2. Calendar Function?
    By Desstro in forum Reports
    Replies: 1
    Last Post: 05-08-2010, 04:41 PM
  3. Replies: 2
    Last Post: 04-23-2010, 01:31 AM
  4. Help with Calendar
    By alanl in forum Access
    Replies: 1
    Last Post: 03-15-2010, 08:16 AM
  5. calendar controls
    By kganomega in forum Access
    Replies: 0
    Last Post: 12-16-2009, 12: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