Results 1 to 10 of 10
  1. #1
    revnice is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    61

    Date Picker doesn't appear


    I've got the data type set to Time/Date and the Properties of the date picker set to, 'Yes, for Dates' but it still doesn't appear in my table column.

    How do you add it to a form? (Access 2007)

    Thanks - rev

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    are you looking at a datasheet view? a actual table? is this in a form or a table?

    (there are no date picker properties i don't think. just a form property that involves the picker)

  3. #3
    revnice is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    61
    First issue, tables:
    I've been trying to add a date picker to a table column by making the data type 'Time/Date' and specifying 'Yes for Dates' in the design view of the table. No joy, doesn't appear.

    Second issue, a form:
    I'm creating an input form that needs a few date fields. I've successfully created an input formatting mask (which appears) but the date picker doesn't.

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by revnice View Post
    First issue, tables:
    I've been trying to add a date picker to a table column by making the data type 'Time/Date' and specifying 'Yes for Dates' in the design view of the table. No joy, doesn't appear.
    you cannot use a date picker in DESIGN view of a table. the purpose of it is to enter data. you don't do this in design view.

    Quote Originally Posted by revnice View Post
    Second issue, a form:
    I'm creating an input form that needs a few date fields. I've successfully created an input formatting mask (which appears) but the date picker doesn't.
    my guess is that masks and pickers do not mix. i would assume that the program doesn't allow the use of both. probably because pickers are programmed and a mask is specified from you and could be just about any format.

  5. #5
    revnice is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    61
    Agreed, but I'm not trying to use in Design View, I'm just trying everything I can think of to make it show up!

    The Help says 'Access provides a date picker' - but doesn't explain when it's going to appear, i.e. under what circumstances, where/how you turn it off or on.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It *only* appears in a form next to a TextBox that is bound to a DateTime field when you run the form. No mask is needed when you use the DatePicker.

  7. #7
    revnice is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    61
    Thanks, I'll check it out.

  8. #8
    MissVinegar is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Jan 2012
    Location
    Belfast
    Posts
    14
    Had the same problem, then removed input mask and it worked!

  9. #9
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Quote Originally Posted by MissVinegar View Post
    Had the same problem, then removed input mask and it worked!
    Thanks for sharing.

  10. #10
    revnice is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Aug 2010
    Posts
    61
    Yes, thanks for that.

    rev

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

Similar Threads

  1. Date Picker?
    By gazzieh in forum Forms
    Replies: 9
    Last Post: 02-09-2013, 09:35 AM
  2. Date picker
    By BI4K12 in forum Access
    Replies: 1
    Last Post: 06-09-2010, 11:11 AM
  3. Access 2003 - how install MS Date Picker
    By alexcalgary in forum Forms
    Replies: 3
    Last Post: 05-20-2009, 09:12 AM
  4. Access Runtime 2007 Date Time Picker Vista not working
    By sailinxtc in forum Programming
    Replies: 0
    Last Post: 09-17-2008, 12:56 PM
  5. Microsoft Date and Time Picker 6.0
    By That Crazy Hockey Dood in forum Forms
    Replies: 0
    Last Post: 07-25-2007, 03:22 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