Date format when I merge to Word

A

Amirallia

HI !!!

I have a problem of Date format when I merge to Word document.
The DosDateRecep field into word returns then name of the month in
German on a computer and in French on another Computer. For example 1
Februar 2007 or 1 Février 2007

Do you know why I have this difference of language ?

Here is my code :

mySQL = "SELECT Format$([DosDateRcv],'d mmmm yyyy') AS DosDateRecep,
FROM TableDos

Set objWord = GetObject(strModel, "Word.Document")

objWord.MailMerge.MainDocumentType = wdFormLetters

objWord.MailMerge.OpenDataSource _

Name:=Replace(Access.Application.CurrentDb.Name, "App", ""), _
ConfirmConversions:=False, _
LinkToSource:=True, _
AddToRecentFiles:=False, _
Connection:="DSN=MS Access Database;DBQ=" &
Replace(Access.Application.CurrentDb.Name, "App", "") &
";DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;", _
SQLStatement:=mySQL

THANKS for yours answers !!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top