Hi
I have a small problem about a calendar use.
I need to mark some weekdays to be holidays and I need to do that for the whole year at the time.
I' using MS ACCESS 2002 and the calendar-component 10.0
jukka
Hi
I have a small problem about a calendar use.
I need to mark some weekdays to be holidays and I need to do that for the whole year at the time.
I' using MS ACCESS 2002 and the calendar-component 10.0
jukka
1) How do you plan to mark them?I need to mark some weekdays to be holidays
2) What is you criteria for selecting those 'some weekdays'?
A good exercise for the Heart is to bend down and help another up...
Please Mark your Thread "Resolved", if the query is solved
Microsoft MVP: 2011 - Till Date IMP Links : Acceptable Use Policy, FAQ
MyGear:
Sony VGN-FZ27G with a triple boot between (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008) and (Win7+Office 2010+VS2010) || Sony VPCCB-45FN with a Win7+Office 2010+VS2010. VM: (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008), (Win8+Office 2010+VS2012) || Mac Book Pro (10.6.8) with Office 2011
You could create a table for holding all the holidays and then when you present the calendar you can do a date range query on the holiday table. Mark any dates returned on your calendar. Then plan to take those days off![]()
VB/Office Guru™ (AKA: Gangsta Yoda™®)
I dont answer coding questions via PM. Please post a thread in the appropriate forum.
Microsoft MVP 2006-2011
Office Development FAQ (VBA, VB 6, VB.NET, C#)
Software Engineer MCP (VB 6 & .NET), BSEE, CET
If a post has helped you then Please Rate it!
• Star Wars Gangsta Rap • Reps & Rating Posts • VS.NET on Vista (New) • Multiple .NET Framework Versions (New) • Office Primary Interop Assemblies • VB/Office Guru™ Word SpellChecker™.NET • VB/Office Guru™ Word SpellChecker™ VB6 • VB.NET Attributes Ex. • Outlook Global Address List • API Viewer utility • .NET API Viewer Utility •
System: Intel Core 2 Extreme Ed., 2 WD Raptor 10K RPM 150 GB HDs RAID 1, 2 GBs DDR2 667 MHz RAM, 3 Viewsonic 17" LCDs, Windows Vista RTM, IE 7, Office 2007
Wish I could do that ... lolThen plan to take those days off![]()
A good exercise for the Heart is to bend down and help another up...
Please Mark your Thread "Resolved", if the query is solved
Microsoft MVP: 2011 - Till Date IMP Links : Acceptable Use Policy, FAQ
MyGear:
Sony VGN-FZ27G with a triple boot between (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008) and (Win7+Office 2010+VS2010) || Sony VPCCB-45FN with a Win7+Office 2010+VS2010. VM: (XP+Office 2003+VB6), (VISTA+Office 2007+VS2008), (Win8+Office 2010+VS2012) || Mac Book Pro (10.6.8) with Office 2011
HiOriginally Posted by koolsid
Actually it might be enough if I could chance the font colour for those days so that user could just see not to select them.
I'd also need to process fridays differently than other weekdays but that can I do in the code too (maybe a radio button to select).
jukka
PS I could use some other calendar componet too if there is any "free" available.
Last edited by jukka; Feb 22nd, 2007 at 01:59 AM. Reason: adding