[AccessD] date format

Thanks Marty,

i will check this.

Pedro
----- Original Message ----- 
From: "MartyConnelly" <martyconnelly at shaw.ca>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, November 14, 2005 10:01 PM
Subject: Re: [AccessD] date format


> You may have different user profiles on different servers, haven't
> played with citrix too much
> I believe there are several ways of setting this via Citrix.
> You might want to call Dev Ashish code to display locale and keyboard
> settings to check when running
> By the way I have heard there are problems with Mail Merge and latest
> Office XP and 2003 Service Pack released in last month.
>
>>
>> CTX103288 - How to ensure users have the desired regional settings
>>
>> http://ctxex10.citrix.com/kb/entry.jspa?externalID=CTX103288
>>
>> you can use this setlocale command line tool. you can add it to your
>> login script. it will then "reset" the regional settings each time a
>> user logs on. you will not have to reboot or logoff first.
>>
>>
>> http://www.spectrodisplay.nl/download/setlocale.zip
>
>
>
> Pedro Janssen wrote:
>
>>Thanks for the help Marty,
>>
>>but something strange is going on.
>>This morning i mailmerged eight times data from access into word.
>>Three times the dataformat for one field (DDatum) was different as the 
>>other
>>five. These three were actualy good, because i changed the format for the
>>wrong outcome, so that i received the right date. So now i even can't 
>>adjust
>>the format wrong or good, because it is changing during the different
>>mailmerge's.
>>
>>Could it have something to do with citrix. We use 15 different servers for
>>access? I thought that the regional control panel settings were the 
>>default
>>settings?
>>
>>Pedro Janssen
>>
>>
>>
>>----- Original Message ----- 
>>From: "MartyConnelly" <martyconnelly at shaw.ca>
>>To: "Access Developers discussion and problem solving"
>><accessd at databaseadvisors.com>
>>Sent: Monday, November 14, 2005 6:13 PM
>>Subject: Re: [AccessD] date format
>>
>>
>>
>>
>>>This might help International Dates in Access
>>>http://allenbrowne.com/ser-36.html
>>>
>>>Also here is code to determine regional control panel settings
>>>http://www.mvps.org/access/api/api0017.htm
>>>called like so
>>>
>>>'?fLocaleInfo(LOCALE_SSHORTDATE)
>>>'?fLocaleInfo(LOCALE_SENGCOUNTRY)
>>>
>>>pedro at plex.nl wrote:
>>>
>>>
>>>
>>>>Hello Group,
>>>>
>>>>i have to date-fields in a table, both with the same preferences and 
>>>>both
>>>>display there data in format dd-MM-yyyy.
>>>>When i use mailmerge with word, with the prps.item i get a different
>>>>result, MM\dd\yyyy and dd\MM\yyyy. In this mailmerge also the function
>>>>TodayDate is used, this gives dd-MM-yyyy. I now have changed the 
>>>>different
>>>>format in the worddocument, to the same output, by using:
>>>>{DOCPROPERTY "GebDat" \@ "dd-MM-yyyy" \*MERGEFORMAT}
>>>>{DOCPROPERTY "DDatum" \@ "MM-dd-yyyy" \*MERGEFORMAT}
>>>>
>>>>How is possible that two the same fields in access give different 
>>>>results?
>>>>Is there a hidden format in the date fields?
>>>>
>>>>When the Date-seperator in the country-preferences is choosen as "-", 
>>>>how
>>>>can access gives "\" as seperator and why not in TodayDate?
>>>>
>>>>TIA
>>>>
>>>>Pedro Janssen
>>>>
>>>>
>>>>
>>>>
>>>-- 
>>>
>>
>>
>
> -- 
> Marty Connelly
> Victoria, B.C.
> Canada
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>