Time formatting issue

[Tom]

Sorry if this is a repeat post - the newsgroup found my post then it went
missing...

I was wondering whether or not Access 2003 has some sort of a configuration
setting where it reads "the first day of the week". I have an app with a
calendar control where on some machines the first day of the week is a
Sunday, others it is a monday.

Any ideas?

-Thomas

 

[Emily]

sorry i cant help if you have any questions about gmail contact me on
hotmail

 

[Tom van Stiphout]

There is no master setting (like in Outlook) to say "wednesday is the
first day of the week", but several functions allow you to specify
what you want the first day to be, including Weekday and others.

A decent calendar control would likely be able to specify this as
well. Consider using one that does.

One gotcha: oleauth32.dll has a long-standing bug where its date math
is off. You can google for it. Some vba functions depend on this dll
so they are wrong as well. I implemented my own routine when accuracy
really mattered.

-Tom.
Microsoft Access MVP

 

[Albert D. Kallal]

Sorry if this is a repeat post - the newsgroup found my post then it went
missing...

I was wondering whether or not Access 2003 has some sort of a
configuration setting where it reads "the first day of the week". I have
an app with a calendar control where on some machines the first day of the
week is a Sunday, others it is a monday.

Any ideas?

-Thomas

The activeX control does have this setting. If you right click on the
control in design mode, choose calendar->options, then there is a setting
for the 1st day of week. I not used the calendar control for about 7 years
now (it burned me too many times). So, use Stephens solution, and eventually
simply made my own sub-form calendar that looks almost like the activeX one.

I seen this behavior. I just not sure where the activeX control gets that
initial setting. However, I would have assumed if you set it in design mode,
then it should stay that way when deploying to a different computer.

 

[Tom]

Thank you all for your help on this.

I'll 'reset' the first day of the week on the control and see what
happens...

Interestingly enough, I found a registry setting which might be causing the
issue.

HKEY_CURRENT_USER\Control Panel\International\iFirstDayOfWeek



I"m not going to modify it, but I want to see if it is different on other
machines..



Thanks again for all of your help!





-Tom