Results 1 to 4 of 4
  1. #1
    83dons is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    15

    Add a simple date picker to an existing form


    I have created a very basic form that lists all the fields and you can also scroll through the entries in the table. This was done simply by highlighting the table, right clicking and going to Create > Forms > Form.

    What I require though is to copy this form but add in the feature that when you open it a popup box appears first asking you to pick a date of birth to search on. Then for only rows with that date of birth to be returned from the source table. I am sure this is simple but I just can't find how to do it most easily!

    Any help appreciated.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    if you have a text box connected to a date field, set the text box format = SHORT DATE.
    then the date picker will show when the cursor hits this field.

  3. #3
    83dons is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    15
    At the moment the date of birth field in the form is just linked to the field in the table. How would I connect a text box to this field so that the data picker will show before the data pulls through into the form from the table?

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    txtbox.control source
    connects the box to the field.

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

Similar Threads

  1. Replies: 8
    Last Post: 10-11-2017, 03:50 PM
  2. Replies: 11
    Last Post: 06-28-2015, 06:42 PM
  3. Form not displaying Date Picker
    By khughes46 in forum Forms
    Replies: 8
    Last Post: 04-10-2014, 12:56 PM
  4. Microsoft Date And Time Picker on Form
    By ccordner in forum Queries
    Replies: 3
    Last Post: 02-21-2014, 12:35 PM
  5. Date criteria using between and form date picker
    By killermonkey in forum Queries
    Replies: 3
    Last Post: 03-21-2013, 12:44 PM

Tags for this Thread

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