View original (French)

Calendar field access

enlérga -  
Hello,

Is it possible to put a small calendar on a field in a form where you click on a date and it will display in that field (like in Excel)??

Thank you in advance.
Configuration: Windows XP Internet Explorer 6.0

4 answers

  1. amigo
    Hello,

    I know two.
    - The Calendar/Date control 9 that displays the selected month with buttons for each day.
    - The Microsoft Date and Time Picker Control 6.0 (SP6) which shows a dropdown list allowing the date to be selected to display in the text box.

    These two controls can serve as data sources for a field on a form.

    A+.
    0
    1. enlérga
      For the first solution that interests me, I don’t know how to do it...
      Could you explain it to me??

      Thank you!
      0
    2. Jimmy59116
      Beginner Grand Access I’m looking to create a planning tool with event reports.

      Long live open forums, you gave me a great solution with this little tip!

      Jimmy
      0
  2. amigo
    Hello,

    In your creation mode form, go to Insert -> ActiveX Control...

    Choose Calendar Control 9 from the list and place it on your form.

    A+.
    0
    1. enlérga
      Thank you, friend!!
      0
    2. enlérga
      One more thing...

      It takes up quite a bit of space, so is it possible to make it disappear after selecting the date and for the chosen date to remain in the field???

      For example, you click in the empty field and then the calendar appears, you choose the date from the calendar, and when it’s chosen the date goes into that field and the calendar disappears.
      0
  3. amigo
    Try the other control I told you about; it will respond better to your needs.

    In the same way, insert Microsoft Date and Time Picker Control 6.0 (SP6).

    It reduces to a text field and when you click on it, it drops down and displays a calendar.

    See you later.
    0
    1. enlérga
      I don’t have this control in my ActiveX controls list...

      (even for the first one for me it was “Calendar Control 11.0”).

      Is there an equivalent??
      0
  4. amigo
    It depends on the access version. In versions 2000 and 2003, these ActiveX controls are found. The names displayed in the list may change.

    If you have a newer version, I would be surprised if they’re no longer there.
    Check again, it should be something like Date and Time Picker Control.

    Otherwise, to answer your question about making it invisible, you can do everything with macros, but it’s quite heavy. You still have to reserve space to display it on the form.
    I don’t know how your sheet is laid out, if there is enough room, why not leave it there?

    Look closely for the Date and Time Picker Control. If you want a peek, when you perform a file search with Windows Explorer and you check the date option, there are two date fields exactly the same.

    See you later.
    0