Results 1 to 4 of 4
  1. #1
    d-mcc56 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2014
    Posts
    16

    Pop Up Calendar for Start and End Dates Help

    Hey all,

    I have created a query that prompts the user for a start and an end date and proceeds with showing the data between those dates.
    I was wondering if there was anyway that instead of the user typing in the dates, a calendar could pop up and they could pick the start and end dates instead?


    If that isn't possible is there anything else that's simpler that I can do? Maybe like a list box for month, date, and year?

    Thanks for your help.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Yes, make a form, on the form put 2 text boxes. call them txtStartDate, txtEndDate. (properties, other tab, name)
    also the property of the text box should default to the calendar pick.

    your query can then reference the form
    [EventDate] between form!frmApp!txtStartDate and form!frmApp!txtEndDate





    I use this for reports too.

  3. #3
    d-mcc56 is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2014
    Posts
    16
    Hey ranman,

    I gave it a shot and it didn't quite work out. I am fairly new to access so I'm sure I've done something wrong.

    I made a form and created two text boxes. I left them unbound and went to properties and changed the names to txtStartDate and txtEndDate.
    I saved the form as frmApp and then I went to my query.
    I changed my field with the criteria "Between [Enter Start Date] And [Enter End Date]" to "[EventDate] between form!frmApp!txtStartDate and form!frmApp!txtEndDate"
    When I tried to run the query I got prompted three things, "EventDate", "
    form!frmApp!txtStartDate", and "form!frmApp!txtEndDate""

    I know I goofed somewhere, if you could enlighten me that'd be great.

    Thanks

  4. #4
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    formS

    formS!frmApp!txtStartDate

    always use the BUILDER. (magic wand icon) It will always spell things correctly for you...just pick it!

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

Similar Threads

  1. Help formatting calendar dates
    By cmb in forum Modules
    Replies: 1
    Last Post: 10-10-2014, 11:06 AM
  2. List Dates between Start and Finish Dates
    By Buddus in forum Queries
    Replies: 1
    Last Post: 07-26-2013, 01:58 PM
  3. Calendar Button to Select Dates
    By CementCarver in forum Forms
    Replies: 9
    Last Post: 04-20-2013, 09:15 AM
  4. Calendar to and From Dates
    By bobfin in forum Reports
    Replies: 10
    Last Post: 08-05-2010, 07:05 PM
  5. Replies: 2
    Last Post: 04-23-2010, 01:31 AM

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