Inserting Date into a Field from Calender

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • haridharmajan
    New Member
    • Aug 2008
    • 8

    #1

    Inserting Date into a Field from Calender

    I Need to add multiple date into a field using calender each date is to be separated by comma ie when I click on the show month it must display calender and when I click on a date it must inser it to that field also I need to insert many date in to single field separated by comma


    help me please
  • puppydogbuddy
    Recognized Expert Top Contributor
    • May 2007
    • 1923

    #2
    See this link for a free popup calendar for Access. Instructions for installation and use come with the download.

    Free popup calendar (month view) for selecting a date in a Microsoft Access database. The calendar is an Access form, so requires no additional VBA references.

    Comment

    • puppydogbuddy
      Recognized Expert Top Contributor
      • May 2007
      • 1923

      #3
      Missed the part about multiple dates in a single control. Try this: Put two unbound textboxes on your form, one (txtbox1) for use with the calendar controlm and the other (txtbox2) with the following expression:

      =txtbox2.value & "," & txtbox1.Value

      each time you change txtbox1, txtbox2 will add the date entered to its current list/

      Comment

      Working...