[AccessD] Access date problem

It's set in vba using the Weekday function and specifying the optional
firstdayofweek argument.  If you just modify your code to include vbSunday,
you should get the desired result.  Have you tried that?

Charlotte Foust

On Mon, Sep 5, 2011 at 9:19 AM, Doug Steele <dbdoug at gmail.com> wrote:

> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>