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