Calendar Function Starts on Monday

[Guest]

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?

 

[Douglas J. Steele]

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

 

[Guest]

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?


--
Bill Ross
Denver, CO

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

 

[Tormod Engebu]

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...

 

[Alex Dybenko]

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

 

[Guest]

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