Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    California, USA
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pop-up date picker calendar (2003 / SP2)

    I am sure I am using the wrong search terms, because this shouldn't be that difficult and I am also sure it has been covered in the past.

    I am building a small database to track training programs in my company. I want to add a pop-up calendar control to select the date of the training class. I have tried adding the calendar control and binding it to the date attended field in the table I am storing records in but that just seems too clumsy. I would like to have a combo box type control with a clickable button to open the calendar and have the calendar disappear when the date is selected.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pop-up date picker calendar (2003 / SP2)

    I have attached a demo using a dropdown calendar - when you click the dropdown arrow, a calendar will appear, and it'll disappear as soon as you select a date.

    The attachment to <post:=254,241>post 254,241</post:> has a demo of a popup calendar.
    Attached Files Attached Files

  3. #3
    Star Lounger
    Join Date
    Mar 2002
    Location
    California, USA
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pop-up date picker calendar (2003 / SP2)

    Hans,

    This is exactly what I need. I hate to sound thick, but how do I get it into my data base? I have tried copying the forms and modules into mine but I get an error message and the de###### opens up.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pop-up date picker calendar (2003 / SP2)

    Which one did you try - the version from this thread or the one from the earlier thread I referred to?

  5. #5
    Star Lounger
    Join Date
    Mar 2002
    Location
    California, USA
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pop-up date picker calendar (2003 / SP2)

    I tried the one from the earlier thread. I have downloaded the one you attached to your response now and I am trying to copy the event into my DB. Any hints on the best way to do that?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pop-up date picker calendar (2003 / SP2)

    For the database from the older thread:
    - Import the form zsfrmCalendar and the module basCalendar into your database.
    - Open your own form in design view.
    - Create a text box on your form.
    - Enter the following expression in its On Dbl Click event in the Event tab of the Properties window:

    =PopupCalendar([Screen].[ActiveControl])

    For the database from the newer thread:
    - Import the form into your database.
    - Open it in design view.
    - Copy the combo box and paste it onto your own form.
    - Copy the code from the demo form into the module for your own form.
    - Create a new calendar control on your own form - do not copy the one from the demo form.
    - Name the calendar control calCalendar.

  7. #7
    Star Lounger
    Join Date
    Mar 2002
    Location
    California, USA
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pop-up date picker calendar (2003 / SP2)

    Hans,

    I used the instructions for the new demo and it works perfectly. As usual, you are the best. Thanks for the help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •