Results 1 to 4 of 4
  1. #1
    S2000magician is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    31

    Calendar thingy for inputting dates

    I have a number of forms in which I need the user to input a date. I have a standard example Access file from Microsoft in which a calendar thingy appears for a text box that wants a date, but I cannot figure out how to get that in my form.



    It appears that it has to do with having the text box bound to a date field in a table, but a) I don't know how to bind the input in a text box to a field in a table, and b) sometimes the date the user enters won't correspond to any date in any table.

    If anyone can help me figure out how to get the calendar thingy, I'd be most grateful.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,932
    ensure the format property for the control is set to a date format and the showdatepicker is set to 'for dates'

  3. #3
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    You could also try my Better Date Picker utility. Its very easy to use and works in all versions of Access, both 32-bit and 64-bit.
    See http://www.mendipdatasystems.co.uk/b...ker/4594398118
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  4. #4
    S2000magician is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    31
    Quote Originally Posted by Ajax View Post
    ensure the format property for the control is set to a date format and the showdatepicker is set to 'for dates'
    Perfect!

    The problem appears to be that I had an input mask for dates (__/__/____). Once I got rid of that (and made sure that everything else was set as you suggested), I got the thingy. Apparently, I was overcomplicating the problem.

    Thanks!

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

Similar Threads

  1. Calendar too small to see dates
    By dcavaiani in forum Access
    Replies: 2
    Last Post: 03-24-2019, 03:33 AM
  2. Replies: 3
    Last Post: 11-03-2014, 03:30 PM
  3. Help formatting calendar dates
    By cmb in forum Modules
    Replies: 1
    Last Post: 10-10-2014, 11:06 AM
  4. Create Sort Order Customization Thingy
    By Carouser in forum Access
    Replies: 5
    Last Post: 09-04-2012, 12:38 PM
  5. Calendar to and From Dates
    By bobfin in forum Reports
    Replies: 10
    Last Post: 08-05-2010, 07:05 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