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 !!!
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 !!!