[AccessD] Access date problem

Hi Charlotte:
Changing all instances of the Weekday function to include vbSunday as the
second parameter did fix the problem.  I'm still curious, however, why one
computer in particular would have vbMonday set as the first day of the week
contrary to the Access documentation.

Doug


On Mon, Sep 5, 2011 at 11:35 AM, Charlotte Foust
<charlotte.foust at gmail.com>wrote:

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