Results 1 to 10 of 10

Date Picker?

  1. #1
    gazzieh is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    26

    Date Picker?

    I have an unbound combo box that is set to take a date (default value is defined and the input mask is set) but the system does not automatically recognise the input as a date and so does not offer the date picker.



    You used to be able to add the date picker and link it to a field so is this still possible in 2007?

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,598
    I believe that if you give the combo a date format (like Short Date), Access will then recognize that it's a date and show the picker.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    gazzieh is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    26
    Unfortunately this doesn't work with a combo box but now I am re-thinking the use of a Combo Box.

    I wanted it to list all previous dates used but now realise that if they simply select a date that has been previously used then the system would work the same and remove the problem of a very long list of dates.

    Thanks anyway.

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,598
    It definitely works with text boxes. I've never used a combo for dates, but a brief test confirms that this doesn't work with a combo. Sorry.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Gdm is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    May 2010
    Posts
    28

    How is date picker triggered?

    I have a bunch of textboxes on my forms, where both format and input format are set to Short Date, but Date Picker is not triggered.
    Am I missing something?
    Thank you.

  6. #6
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    I'm having the same issue as Gdm. Date picker is gone from text boxes. I swear I've seen it work before. Am I just confusing my 2003 at work with 2007 at home?

  7. #7
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,598
    The date picker that automatically shows up for date fields was introduced with 2007. In 2003, you had to "roll-your-own" or use an ActiveX control (which personally I don't like to do). I use one I got from a now defunct site, but there's also this one:

    http://www.mvps.org/access/forms/frm0057.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  8. #8
    fscripca is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2013
    Posts
    1

    Date picker for combo box Access 97 SOLVED

    As you know date picker works only text box but sometime is need this tool for combo box.
    I use a form that have a field name Data (Date/Time formatting)
    This is a field that work to put data into and i need to make a search for record using a standard data picker.
    But that is not possible using a combo box and without combo box I cannot search nothing.
    So for searching I use a combo box (simple using wizard and option "find in record")
    This wizard put in After Update event a embeded macro (SearchForRecord but it does not work for date/time field)

  9. #9
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,598
    The same code should work for a textbox, though it probably requires tweaking for a date. This type of thing:

    Dim rs As Object

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[FieldName] = #" & Me.TextboxName & "#"
    Me.Bookmark = rs.Bookmark
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  10. #10
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    2,898
    Quote Originally Posted by gazzieh View Post

    ...I have an unbound combo box that is set to take a date (default value is defined and the input mask is set)...
    The question about using a Combobox aside, the Access-native DatePicker in 2007/2010, does not work if you also have an Input Mask set for the Control in question.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Time picker for Access 2003
    By Thiyagu in forum Access
    Replies: 1
    Last Post: 03-24-2010, 06:36 AM
  2. Access 2003 - how install MS Date Picker
    By alexcalgary in forum Forms
    Replies: 3
    Last Post: 05-20-2009, 09:12 AM
  3. Access Runtime 2007 Date Time Picker Vista not working
    By sailinxtc in forum Programming
    Replies: 0
    Last Post: 09-17-2008, 12:56 PM
  4. 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
  5. Replies: 1
    Last Post: 12-09-2005, 10:29 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
  •  
Tech Forums: Microsoft Office Forums