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

Posted on 2003-02-20
Medium Priority
Last Modified: 2013-11-28
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?
Question by:NeilRahc
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

lonkie74 earned 600 total points
ID: 7992039
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

Expert Comment

ID: 7992547
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.

Author Comment

ID: 7997107
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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
There is a massive demand for content on the web right now, and it doesn't look like it's going to stop any time soon. But, if you are running a business blog, it's not just enough to offer your audience lots of content. It needs to be high-quality…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question