UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Calendar Popup (Date Picker), Month/Year/Events Calendar Styles    
 
   
gary84
post Nov 2 2008, 12:00 PM
Post#1



Posts: 369
Joined: 20-May 07



Update, Version 2008-08-11-0 (Supercedes Version 2007-05-25-0)
mprovements:
Now there are 3 Calendar Styles: Mini-Month, Whole-Year, and Events-Months.
The Date-Picker Function is redesigned to minimize the amount of customization that must be done when the tool is reused elsewhere.
Double-Click works in Events Months.
-------------------------------------------------------------------
I wrote these calendar tools as drop-in forms for any database where I need a date picker.
These are configured for 2003, but they will should work in all other versions too once the References are set up. Search for the word References in the code to learn more.
Contains:
1. Example of a straightforward date picker.
This uses a popup form called "CalendarPopup".
Keyboard shortcuts:
Days: Cursor Up, Down, Left, Right.
Months: PageUp, PageDown.
Years: Shift PageUp, Shift PageDown.
Today: Home.
Return or Space to save selection & close.
Escape to Close without saving selection.
The mouse works too, but I'm all about the keyboard shortcuts, because with them you can zip in, select, and zip out in a second or two. If there is a faster way to pick dates, I haven't seen it.
2. Example of a Scheduled-Events-Table tool that uses the Events Calendar.
This uses a popup form called "CalendarEvents" which has everything that "CalendarPopup" has, plus the "Description" field of the "CalendarEventsTable" records appears in the context of the calendar. It allows you to change the overall width and height of the calendar. You can go into the module and permanently change the values, if you know how many twips tall and wide you want it to be on your particular display.
Each Record in the Sample Table has two set-able Dates: DateDue, and DateDone. I use this to track my future Checking Account transactions, because they are a mix of Manual and Automatic payments, making then sometimes tricky to keep track of. This tool helps me predict exactly what payments are due, and whether they got paid, which prevents me from missing payments, and accidently making double-payments.
Click on the Datasheet Option Buttons to use the Date Picker to automatically populate the spreadsheet with the Dates you select.
Enjoy. Let me know if you like it.
Attached File(s)
Attached File  Multi-Calendar Data Picker with Events 2008-11-02-0.zip ( 227.78K )Number of downloads: 880
 
Go to the top of the page
 
gary84
post Nov 13 2011, 11:54 AM
Post#2



Posts: 369
Joined: 20-May 07



It has been awhile since I posted an update to my Multi-Calendar Date Picker.
Simplified the popup call, it's just two lines of code long now.
Added calendar-format picking buttons to the top left of each calendar.
There's lots of Date Pickers out there. This is the only one I use. It behaves the way I want it to.
Attached File(s)
Attached File  Date_Picker__Multi_Calendar__2011_11_13_0.zip ( 454.16K )Number of downloads: 560
 
Go to the top of the page
 
l3iodeez
post May 5 2015, 10:40 AM
Post#3



Posts: 72
Joined: 8-October 07



I modified your mini date picker to allow selection of multiple dates and insert those dates to a table. I found this page when searching for a similar control and Im posting this here for anyone else who has a similar problem. It would pretty simple to convert this to using a VBA array instead of a table, but for my purposes I needed to use a table.
Attached File(s)
Attached File  MultiDate_Picker_2015_05_05.zip ( 28.59K )Number of downloads: 254
 
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    16th December 2017 - 10:00 AM