[AccessD] Access date problem

William Benson vbacreations at gmail.com
Tue Sep 6 23:03:54 CDT 2011


Obviously that computer was built on a Monday? Its always been GM's excuse.
On Sep 5, 2011 5:14 PM, "Doug Steele" <dbdoug at gmail.com> wrote:
> 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
>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



More information about the AccessD mailing list