Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-30-2018, 04:53 AM   #1
ridders
Part time moderator
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,185
Thanks: 83
Thanked 1,526 Times in 1,423 Posts
ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice ridders is just really nice
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

https://www.access-programmers.co.uk...10#post1533910

Having just spent a long time searching for the thread, I'm posting it here so its easier to find in the future!

The original version by Brendan Kidwell is open source from 2003 and can be found here:
http://www.glump.net/content/accessdatepicker/

However, I've made extensive changes to the appearance of the calendar form



If all you want is a visual calendar, it will certainly do that
However, its main purpose is to input a date in a form textbox
All you need for that is one line of code in the textbox click event:

Code:
Private Sub txtDate_Click()
    InputDateField txtDate, "Select a date to use this on your form"
End Sub
The string "Select a date to use this on your form" is used for info on the form and can be adapted to suit

To use, copy frmDatePicker & modDatePicker to your own database
Ignore frmMain - its only needed for the example db
Attached Images
File Type: png DatePicker.PNG (24.2 KB, 959 views)
Attached Files
File Type: zip DatePicker.zip (90.9 KB, 325 views)

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

New example databases:

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

-----------------------------------------------------------------------------------
nil illegitimi carborundum est

Last edited by ridders; 02-01-2018 at 01:23 AM.
ridders is offline   Reply With Quote
The Following User Says Thank You to ridders For This Useful Post:
Frothingslosh (01-31-2018)
Reply

Tags
date picker; 64-bit

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Code for Date Picker Use AND User Date Entry JessicaGomo Forms 2 03-27-2015 06:45 AM
Hiding the date picker from date fields penfold1992 Queries 2 11-05-2013 08:32 AM
Date Field in a Search Form with a date picker option oblivion86 Forms 3 08-28-2012 05:53 AM
2007 Date Picker on a from how to set default date to +5 daysú Singlespeed Forms 1 03-02-2011 07:51 AM
Textbox calendar - date picker - event to close after date made Rx_ Modules & VBA 1 10-28-2010 11:59 AM




All times are GMT -8. The time now is 11:31 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World