Hi James,
Popup Calendar that works with Access 2007 and above!
I posted a Popup Calendar form here:
http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/Crystal/
PopupCalendar_Crystal_120627_ACCDB.zip
f_PopupCalendar_Test loads automatically when this database is opened.
To use this feature in another database, import:
f_PopupCalendar.
I
usually assign this Double-Click [Event Procedure] to each date control:
DoCmd.OpenForm "f_PopupCalendar"
the popup calendar reads the ActiveControl to get date and, optionally, time. When OK is clicked on the popup calendar, the control you came from is updated with what was chosen.
Feedback is appreciated, thank you.
Warm Regards,
Crystal
http://www.AccessMVP.com/strive4peace
*
(: have an awesome day :)
*
________________________________
From: Crystal
Sent: Friday, June 15, 2012 9:29 PM
Subject: Re: [MS_AccessPros] Re: Calendar
Hi James,
I have recently written a replacement for the ActiveX Calendar control that was depreciated in 2007. I still have to pull it out of where it is and write an interface to hook it up to resident tables ... Pat Wood is going to help me ;) Ideally that will get done in the next couple weeks -- I'll post it on RogersAccessLibrary.com (MVP Libraries) and here ... so check periodically if you are still looking for ideas
If you are wanting something that is capable of colorful reporting, I have code to output data from a query that you specify to HTML format and it lets you set colors ... it isn't posted yet but I will try to remember to dig that out too
Warm Regards,
Crystal
http://www.AccessMVP.com/strive4peace
*
(: have an awesome day :)
*
________________________________
From: Duane <duanehookom@hotmail.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, June 15, 2012 7:49 PM
Subject: [MS_AccessPros] Re: Calendar
I have a sample annual calendar report at http://www.access.hookom.net/Samples.htm. It's real basic but might get you started.
Duane Hookom
MS Access MVP
--- In MS_Access_Professionals@yahoogroups.com, "James" <jewedel@...> wrote:
>
> I would like to be able to draw out a year's worth of calendars and have various dates colored in based on a table of stats, days closed, etc. This is not a date picker calendar, just a display of the year. Are there any links to this type of thing already done? If not where would I start?
>
> James
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar