Date Time Picker. Calendar and Clock Forms.

This is a video walkthru of my new Microsoft Access Date and Time Picker Template. The purpose of this video is to show you all of the features in the template. You can purchase the template for your use at the link provided below. If enough of you want to see how this database was built, I would be happy to record a detailed lesson video, but for now it's available only as a template.

I do cover how I built the Calendar Control Template in my Access Calendar Seminar and the techniques are very similar. This database uses ONLY Microsoft Access to provide you with a popup calendar date picker form and a popup time picker form. I hate external objects (DLLs, COM objects, etc.) Microsoft removed the built-in calendar control in Access 2010, and they replaced it with a simple date picker popup in the control. Some people (including me) want more control over that date popup. So, a few years ago, I created my Calendar Control Replacement (see link below).

Watch the walk-thru video. You'll see all of the features included in this template. You can use this as a popup form, or embed it inside of your other forms. And of course, it's completely customizable and you get the full source code when you purchase the template.

Sample Database

If you'd like to download a sample copy of the database template, you can do so here. This is a non-editable version of the template which will let you see it work in action. Sample database only available for 64-bit version of Access.

Full Developer Database

Once you have purchased the full developer database template, come back to this page and click on the Download button below. This will give you access to the ZIP file containing the Template ACCDB file. The full version will run on 32-bit or 64-bit Access 2013 or higher.

Updates

Since the database was first published, I added one new feature. If you double-click on the year in the popup calendar form, it will ask you to input the year. I always hate having to click... ehem... 30 times to the left to select my birthdate year. OK, OK... 40 times. LOL

Full Video Seminar

If you would like to learn how this database was built, again, pick up a copy of my Access Calendar Seminar. It covers all of the basic concepts. If you want to see how this database, specifically, was built, then let me know. if enough people are interested, I'll record it as a separate lesson.

License

For internal use only. This template does NOT come with a royalty-free license. You may only customize the template for your business needs and for use within your organization at one location ONLY. You may not resell or distribute any form of this template to others without express written permission. Contact me for additional information on obtaining a license to distribute if you plan on including this template in a product you are reselling. Additional licenses are required if you plan on using this template with more than ten (10) employees or in multiple locations within your organization.

Not a Finished Product

Please keep in mind that most of my template databases are not designed to be finished products that are ready to go in a working environment. My templates are meant as starting points for you to customize for yourself so you don't have to reinvent the wheel. This requires that you have a basic understanding of Microsoft Access development. To work on most of my databases you should have completed my Access Beginner series and the first couple levels of my Expert series at a minimum. Most of my databases require knowledge of SQL and VBA as well. Keep in mind that most of my templates are not like off-the-shelf software. They're starting points for developers to be able to modify and use as their own. It really is going to be in your benefit to watch all of the prerequisite videos so you understand the database and how it works moving forward. This is not like QuickBooks where you just install it and use it. My templates are mostly designed for people who already have an understanding of how Microsoft Access works.

Customize For Your Needs

If you would like to discuss customizing this template for your needs, and integrating it into your current setup, please see my consulting page for details. While I no longer accept custom jobs that are specific to a single user, I may include your features in a future version of this template if they have mass appeal. If you are looking for custom enhancements made to this template just for you, visit my Developer Network.

Technical Support

Please note that technical support is NOT guaranteed for any of my courses, seminars, or templates. If you require help with modifying this template, you may post a question in the Forums, however an answer to your question is not guaranteed. If this template comes with an accompanying Seminar, then you should purchase that Seminar to see how the database was constructed. If not, then you should have taken the suggested courses. Most of my templates are designed on a Developer level and you should have a thorough understanding of SQL and VBA before attempting to modify them. If you have a problem with one of my databases, I will only support the unmodified database exactly as it's downloaded from my site. If you have modified it in any way, it may not be something I can help you with. You can post in the Forums, and I may be able to help you, but if the issue doesn't exist in my unmodified database, it's not something I can support.

Questions?

Got sales or customer service questions about this template? Feel free to contact me. If you have technical "how do I" questions about this template, you discover a bug, or want to suggest a new feature, then please post your comments below.

Keywords

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #templates, calendar control, calendar popup, calendar template, date time picker, clock control