Results 1 to 4 of 4
  1. #1
    JLL12345 is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    2

    Attaching dates to drop down check boxes

    Hello,



    My use of Access is very limited so excuse me if I have posted this in the wrong place.

    I want to be able to attach a date field to a dropdown check box. For example, say I have a client who we submit multiple deliverables to on different dates. I want to be able to check the deliverables submittted and add the date for that deliverable (each deliverable has a different date). Please see the attached image which is how the drop down is currently set up.

    Click image for larger version. 

Name:	Untitled-1.jpg 
Views:	4 
Size:	59.2 KB 
ID:	15312

    Thank you!

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Dates are usually stored in fields within tables using the data type, Date/Time. You can input data into tables using forms. A control on a form can employ an intrinsic Date Picker to help insure correct user input.

  3. #3
    JLL12345 is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Feb 2014
    Posts
    2
    Thank you. I am a true novice so am not even sure what you were trying to say. Is what I am looking for possible or not? Thank you!

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    What I am trying to say is you should be using forms to populate your tables with data. Forms are used as input methods. Create a form for a user interface. Users open forms and enter data into the DB via forms.

    I don't know what a "Drop Down Check Box" is. If your task at hand is to "View" data in the tables, you can use forms and also reports as an interface. A date field will not appear until after it is created.

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

Similar Threads

  1. How to search via drop down boxes
    By MaxP in forum Access
    Replies: 2
    Last Post: 01-12-2015, 10:13 AM
  2. Replies: 1
    Last Post: 03-29-2012, 12:20 AM
  3. Two questions on drop down boxes
    By martinbanks in forum Access
    Replies: 3
    Last Post: 12-06-2010, 04:01 AM
  4. To check or Un-Check all Boxes in a form
    By devcon in forum Forms
    Replies: 7
    Last Post: 05-01-2010, 12:03 AM
  5. Drop Down In From Boxes
    By Nelson12 in forum Forms
    Replies: 5
    Last Post: 02-04-2010, 12:34 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