[AccessD] Calendar control

Erwin Craps - IT Helps Erwin.Craps at ithelps.be
Thu Apr 14 01:56:48 CDT 2005


I take a look at it. I see it based on the common controls library wich
contains the date/time picker from ms.

I only see that it base on a click-a-control principle while a need a
fix month view on the main form.
But I will check it out.

thx

Erwin

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Wednesday, April 13, 2005 7:59 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Calendar control

How about using Stephen Lebans Calendar control.
It is a wrapper around common control api calls so should be no
versioning problem http://www.lebans.com/monthcalendar.htm

Erwin Craps - IT Helps wrote:

>Yes indeed, but the control is connected to the office version.
>You can not use the A2K3 calendar control on a A2K machine, the A2K 
>calendar control stays..
>
>I dont know how to check the calendar control version, but the access 
>version must be simple.
>
>I'm looking at other controls like the Microsoft Date and Time
picker...
>Looks nice to.
>
>Erwin
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
>Sent: Wednesday, April 13, 2005 1:09 PM
>To: accessd at databaseadvisors.com
>Subject: RE: [AccessD] Calendar control
>
>Hi Erwin
>
>Looks like a bug to me as vbSunday is 1 in all versions of Access.
>But it's a bug of the control not Access, so you should check the 
>version of the control (or rather the reference to the control), not of

>Access.
>
>/gustav
>
>
>  
>
>>>>Erwin.Craps at ithelps.be 04/13 12:52 pm >>>
>>>>        
>>>>
>I believe I explained myself poorly...
>
>The issue is that Calendar control of A2K has 1 (vbSunday) for Sunday.
>The calendar control of A2K3 has 1 (vbSunday) for Monday.
>So the calendar control of A2K3 already use the system local firstday.
>
>But thats the problem...
>If I set the calendarcontrol of A2K3 firstday property to 1 I get 
>Monday as the first day.
>If I move that database to a A2K pc, the calender control will display 
>Sunday as the first day.
>Because In VBA Sunday should always be the first day (vbSunday
Contant).
>
>So probably the only soluation is to check which version of 
>calendarcontrol or Access is running and set the firstday to 1 or 2 
>according to the access version.
>
>Or not using the calendar control :-(
>
>Erwin
> 
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
>Sent: Tuesday, April 12, 2005 5:56 PM
>To: accessd at databaseadvisors.com
>Subject: RE: [AccessD] Calendar control
>
>Hi Erwin
>
>A clue is here:
>
>  http://www.vb-helper.com/howto_set_calendar_first_weekday.html
>
>/gustav
>
>  
>
>>>>Erwin.Craps at ithelps.be 04/12 5:27 pm >>>
>>>>        
>>>>
>Ok, this seems like a bug to me.
>
>The A2K calendar control give for Monday as the firstday, the A2K3 
>calendar control gives Tuesday as the firstday when having the property

>.FirstDay set to vbMonday (2)
>
>Fun fun fun
>
>Anyone knows how I can get the Windows system firstday?
>
>Erwin
> 
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Erwin Craps
>-
>IT Helps
>Sent: Tuesday, April 12, 2005 5:05 PM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] Calendar control
>
>Is there a bug in the calendar control of MSA2K3?
> 
>When using a MDB file in A2K3 my firstday is monday.
>When using this MDB file on a A2K computer the firstday is sunday and 
>the dates are so small they look like a dot.
>It seems that the font is set to 1.5 instead of 8.25.
> 
>So in an attempt to solve this I VBA code my fonts to 8.25 and my 
>firstday to vbMonday.
>Should be right?
> 
>No way, When looking to my calendarcontrol in MSA2K3 the firstday is 
>tuesday!!!
>I supose it will be good in A2K, but how am I to work around this one?
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>  
>

--
Marty Connelly
Victoria, B.C.
Canada



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list