Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1178
  • Last Modified:

MS Access: Pop up a calendar to choose a date?

Is there a relatively easy way to pop up a calendar and pick a date?

In a fill-in form I have it so that the date will default to today.

It would be cooler to pop up a little calendar window (the MS Contact sample database does this but I don't see how) and pick a date and have scrolling months and years.

Maybe there's something out there somewhere available to pick up?
1 Solution
Yes, in access 2k with SP4 you have access to the "microsoft data & time picker control 6.0" control.

this gives a popup calendar where you can select the day and scroll through the months. if you click on the year you can scroll years
I have a similar function on some of my programs. I'm using Access 97, and I use the ActiveX calendar control. I've placed it on it's own small form, and placed a button next to the text box that is to contain my date. then on clicking the button, the form pops-up and stays there, until the user selects a date or clicks cancel.
NeilRahcAuthor Commented:
You guys are great - thanks for your q-u-i-c-k response! I'm going to accept on faith that both solutions work and I will award you both with points. I will look into both approaches.

This is a great forum - I've really gotten some excellent help from you guys who contribute to it.

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now