[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