Calendar Function Starts on Monday

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill Ross - 09 Aug 2005 16:45 GMT

I have as Access 2003 application that uses the calendar so that a user can
choose a date from a form. The front end is installed on about 20 computers
and on only one computer the Calendar starts on Monday rather than Sunday.
When the user clicks the "Today" form button the following code is run:

XCALENDAR.FirstDay = 1
...

Any ideas?

Signature

Bill Ross
Denver, CO

Reply to this Message

Douglas J. Steele - 09 Aug 2005 22:40 GMT

Is there a difference in the regional settings for that one computer?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I have as Access 2003 application that uses the calendar so that a user can
> choose a date from a form. The front end is installed on about 20
[quoted text clipped - 6 lines]
>
> Any ideas?

Reply to this Message

Bill Ross - 10 Aug 2005 03:38 GMT

Hi Doug,
Thanks for the reply. No, the regional settings and the MSCAL.OCX are the
same as the rest of the computers.

Any other ideas?

Signature

Bill Ross
Denver, CO

> Is there a difference in the regional settings for that one computer?
>
[quoted text clipped - 8 lines]
> >
> > Any ideas?

Reply to this Message

Tormod Engebu - 16 Sep 2005 12:44 GMT

Hi

I got the same problem
I've used the mscal.ocx object, and on my (developer) pc the date and
calendar are set to Firstday = 2, cause in Norway we start our calendarweek
on Monday. This works on my computer, but on my clients computer the
calendar starts on Tuesday.

I'm starting to believe there is some kind of regional settings problem here,
cause I know I run Win XP US-English but with norwegian setup (currency,
date/time etc) but my clients run Norwegian 2000/XP.

Guess I mught have to query the computers LCID or something to determine
what FirstDay-value to use...

Reply to this Message

Alex Dybenko - 16 Sep 2005 14:09 GMT

Hi,
Calendar control has a property FirstDay, try to set it to Monday

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Hi
>
[quoted text clipped - 12 lines]
> Guess I mught have to query the computers LCID or something to determine
> what FirstDay-value to use...

Reply to this Message

Bill Ross - 16 Sep 2005 17:20 GMT

Hello Alex,

Thanks for the reply. I realize there is a FirstDay property (see start of
feed) - the problem is that the calendar on one computer shows different days
than on other computers within the same office and version. Although I have
no proof, it seems that the international versions of MS Office have various
and sometimes non-working versions of the MSCal.ocx depending on the region.

I currently have a user in China that gets 9/14/2003 when today's date
(=date()) is set on the calendar. The computer has the correct date/time.

Go figure.

I wish someone from Microsoft would notice this issue ----

Bill Ross
Denver, CO

> Hi,
> Calendar control has a property FirstDay, try to set it to Monday
[quoted text clipped - 15 lines]
> > Guess I mught have to query the computers LCID or something to determine
> > what FirstDay-value to use...

Reply to this Message