Date Pickers, Calendar Controls, and Calendar resources (1 Viewer)

[MajP]

There has been some recent interest in a replacement for the MS calendar control that existed prior to 2010. I have been collecting date pickers, calendar controls, and calendars for a long time and thought it would be a good idea to have one thread with lots of good examples. Some of these are mine, but many are not. I will add links and other examples as I get them and feel free to post examples and links. In my mind there are three different things but often just get called "calendar control", so that can be confusing. For the purpose of this thread I would like to use the terminology

1. Date Picker: This is a pop up that returns a date to a control and defaults to the value in the control
2. Calendar Control: Same function as a date picker but resides on the form
3. Calendar: Allows you to put information in a day and display it. This require more than just a form because you have to have the underlying table to save information.

Example of a Date Picker from @isladogs

A better date picker

Some months ago I uploaded a replacement date picker (see DatePicker.accdb attached) that has no Active X controls and can also be used in 64-bit Access. It was originally posted in response to a question about Stephen Lebans' calendar in this thread...

www.access-programmers.co.uk

Better Date Picker - Mendip Data Systems

Database applications for businesses, schools and individuals

www.mendipdatasystems.co.uk

Example of a Calendar Control. In this case the same form can be used as a pop up date picker or reside in the form as a Calendar Control

Calendar

Simple one month Calendar

Here is the most complicated calendar I have built. It is a one year view that allow you to display different codes in different colors and even multiple colors in a single day. See 1 Feb.

 

[MajP]

Calendars

From @Gasman

Calendar/Appointment database

***** Please use the link in post #7 ***** Hi, I have been asked to submit the database attached as it might prove useful for someone else in the future. A request was made in this thread for help in changing the display from Sun - Sat, to Mon - Sun. The code has not been exhaustively tested...

www.access-programmers.co.uk

The Peter Hibbs calendar below is a full "outlook like" calendar application.

UtterAccess.com

utteraccess.com

 

[MajP]

Some of them I provided are listed in this thread, but I have not looked at all of them.

Calendars and Microsoft Access

Here is a good calendar

Creating a Form that looks like a monthly calendar to input employees work schedule

Hello, I am creating a database to help me schedule my employees work hours and was wondering if anyone could lead me in the right direction to creating a form that looks like a monthly calendar that i can click on the day, and it pop up a window that allows me to add a work shift within that...

www.access-programmers.co.uk

 

[MajP]

Another Date picker that is customizable and can be used in Excel and Access

Google Sites: Sign-in

Access Google Sites with a personal Google account or Google Workspace account (for business use).

sites.google.com

 

[moke123]

FWIW, I thought I'd add one that I have. Includes a Calendar, a DatePicker, and a TimePicker.

The Calendar is a simple Event Calendar - Date, Event Description, and Time.
Uses a dictionary object so requires a reference to MS Scripting Runtime.

The date picker is a custom class

The TimePicker is a custom class.
The simulated spinner control can be customized as to the minute increments.
The default is 5 mins.

 

[The_Doc_Man]

This statement is NOT intended to downplay the efforts of ANYONE who has built their own calendaring system. A thousand requirements could exist that force you to use one of these excellent solutions to keep things as "pure Access." And I fully understand that such requirements could exist. Business is funny like that.

We cannot forget, however, that if you have Access, you probably have other parts of Office. IF you have Outlook, the "calendar" wheel (including shareable calendars and future-dated task reminders) has already been invented. Regarding MajP's categories, this statement does not apply to Date Pickers or Calendar Controls, only to full-functional scheduling calendars that are more than just a simple (or complex) control.

When considering cost to implement at a site and complexity to maintain, the Outlook calendar isn't that hard to use, is readily shareable, and is easy to control via VBA code as an app object to update it with tasks requiring reminders, tasks requiring ToDo list entries, etc. Further, if you work for a government agency, they might actually bar use of code that doesn't come from a company that will stick around to maintain it. Some government regulations say that you can't buy someone else's code if there is no customer service department associated with the vendor.

All I am saying here is that if tech difficulty or code support requirements are a factor in your solution, don't ignore off-the-shelf items like Outlook. If you need an all-Access solution and don't face software support issues, the offerings from the various people here are definitely things to consider. They are all highly competent people.