Doug Steele
dbdoug at gmail.com
Mon Sep 5 11:19:30 CDT 2011
Hello All:
I have some code which depends on the weekday number. On all computers
except for one of my client's, it runs OK. The computers are a mixed bag of
Access 2003, 2010 and Windows 7 and Vista.
On the 'bad' computer, everything is off by one day. Debugging on this
computer gives '7' as the result of Weekday("9/4/2011") - a Sunday.
According to Access help, the default for Sunday is 1. I've checked the
Windows 7 Regional and Language settings on this computer and 'Sunday' is
set as the first day of the week. So Access and Windows are different.
I can't find a setting in Access to change this, and nothing on the Web.
But it must be some kind of configuration setup - does anyone have a
suggestion?
Thanks,
Doug