Mail Merge is Reversing My Dates

[b_karv]

Hi I am running an Access program on a network. It's function is to grab some data including a Date and then mail merge it to a word template letter.

The 3 Computers are running WinXP with Word 2001 with Access 2001.

What is happening is that on 2 computers when a mailmerge is done they are displaying the date as reversed ie 9th Decemeber 2004 as 12th September 2004....I live in Australia so we support dd/mm/yy.

On the other computers it works fine.

Now interestingly if I change the data type in the table where the data is being grabbed from to a Text type instead of a Date type, the date is displayed corectly on the two computers that it wasn't working on before and incorrectly on the computer it was working on initially.


On all computers the regional settings are set to Australia.

Any help suggestion will be very welcome as it is vital for me to run my program on all computers via network

Thankyou in advance

 

[mdemarte]

Well, my first message got lost. Here goes again. Sounds like a formatting problem. First guess is the table itself, second is in the template, or maybe in the program. Are all 3 users definitely using the same program and the same template?

 

[karmahum]

My experience with Mail Merge is that you should not adjust formating in Access, but rather in the Word Template. Highlight the field and press ALT+F9 to display field codes, and then add switches to the merge fields.

 

[vand_uk]

im having this same problem. i've tried adding switches to the end of the code but it doesnt solve it! What switches do u recommend?

 

[vand_uk]

been researching this myself, check out
http://support.microsoft.com/default.aspx?scid=kb;en-us;304387

hope it helps, thanks

 

[b_karv]

Well, I had done the above but it caused it to work one computer but not the other. And if switched it around it will do vice verse on the comps.

I found what was going wrong. What it was, word date settings NOT the computer was set to as a US date.

Also there are things called smart tags, which automatically change things to US date fomrat within Word. So you have to put it to the right setting aswell.

 

[Crilen007]

Someone has their system settings set to Something else.

Check them in

Control Panel: Regional and Language settings

 

[b_karv]

After talking to microsoft the solution to this problem was:

1. Set to regional settings to right country this also includes the Language tab in regional settings (located in control panel)

2. Get latest update OFFICE(SP3), JET SP8 & Access Update

After we the 2nd option, the dates merge correctly....so far it is anyway. Don't want to jinks myself

 

[Crilen007]

So the solution was what i said? heh. Change the regional settings.. ive had it happen a few times.