Several good folks here at UtterAccess have contributed to this demo project, (see the properties and code comments). This is a compilation of a date picker that will pop-up next to the control that called it; a time picker that will also pop-up near the control that called it; two different time range selectors; a date difference calculator that displays a date/time difference in days|hours|minutes; a calendar schedule; an analog clock with swappable clock faces and group of new icon images in a form with a few graphical elelments for nifty form design.

VERSION 3 !
NOW UPDATED WITH A CALENDAR REPORT ! Thanks to Dennis (doctor9) here at UtterAccess, this demo now has a report modeled after the large calendar form. Contributors also include, (nut not limited to datAdrenaline, Bob Raskew and Stephen Yale)

The "Date as Words" (also in the Code Archive) has been reworked to render Time as well. Several new features in the modGlobalVars module.

This is compiled and is presented with Access 97, 2K & 2K7 formats. (All tested and working - 2K will work in 2K3 and the 2K7 will work in 2K10.) Hopefully you will find this useful.

(IMG:http://www.endprod.com/scrshts/timepieces/timepiecesani.gif)
(click the image to download the Access 97/2K/2K7 mdb/accdb file in zip format - 1.5mb)

 TimePieces.zip ( 1.47MB ) Number of downloads: 208
(download number before update was 1,751)

Update Nov 28, 2012 - cleaned-up & added some code to include the latest DateTime Functions module - by Cybercow

Be sure to check out the posts below for other features, corrections and modifications.

And as always, ensure any date code matches the syntax for your specific world location.

DanielPineault,

From what I can tell, that section of code is meant to move the date picker near the place you double-clicked, if possible.

My monitor is set up for 1024x768 pixels. When I invoke the datepicker subform from the demo form and trace the code, my values are:

WidthInPixels: 272
HeightInPixels: 151
GetScreenResX: 1024
GetX: 482
XPos: 377
GetScreenResY: 768
GetY: 435
YPos: 370

Your XPos value seems REALLY high. Are you using two adjacent widescreen monitors with really high resolution settings?

Hope this helps,

Dennis