Since upgrading from old laptop (Windows 98) to new laptop (Windows XP), my
mail-merge letters are doing strange things with date formats. For
instance, my reminder letter for lapsed subs carries the 'expiry' date as a
merge field from the database, and this previously was shown as dd/mm/yy (UK
format). Now it persists in showing as mm/dd/yy. I've gone to the Windows
Control Panel and made sure that my Regional settings show UK format, even
deleted the option for US format! On the database the date format inputs
correctly, but the mail merge doesn't!
I can't send letters out with this format, as we don't read dates this way
in UK. For instance, someone whose subs expired on 1st October 2003
(01/10/03 in UK format) would get a letter saying their subs expired on 10th
January 2003 (10/01/03 in US format!)
I've even tried amending the input mask for dates, but the mail merge letter
still shows 'expiry' as mm/dd/yy.
Can anyone help me sort this out?
Many thanks
Ishbel Kargar 8 2227
Waste of time asking for subs from someone who has expired :-(
"Ishbel Kargar" <ik@radmid.demon.co.uk> wrote in message
news:bq*******************@news.demon.co.uk... Since upgrading from old laptop (Windows 98) to new laptop (Windows XP),
my mail-merge letters are doing strange things with date formats. For instance, my reminder letter for lapsed subs carries the 'expiry' date as
a merge field from the database, and this previously was shown as dd/mm/yy
(UK format). Now it persists in showing as mm/dd/yy. I've gone to the
Windows Control Panel and made sure that my Regional settings show UK format, even deleted the option for US format! On the database the date format inputs correctly, but the mail merge doesn't!
I can't send letters out with this format, as we don't read dates this way in UK. For instance, someone whose subs expired on 1st October 2003 (01/10/03 in UK format) would get a letter saying their subs expired on
10th January 2003 (10/01/03 in US format!)
I've even tried amending the input mask for dates, but the mail merge
letter still shows 'expiry' as mm/dd/yy.
Can anyone help me sort this out?
Many thanks
Ishbel Kargar
Dear Phil Waste of time asking for subs from someone who has expired :-(
Thanks for your comment, quite logical I suppose, unless you know the people
I'm dealing with.
We are a small organisation and most of us know each other. Subs reminders
usually prompt an apologetic 'sorry I forgot to renew', together with a
cheque!
The letter I gave as an example was just one of several mail-merge letters,
and I really do need help with the date format problem.
So I still hope someone can help with the problem.
Regards to all
Ishbel
Two thoughts
1) Is the Control Panel Regional and language Options set correctly
2) Might be worth trying to show the date Format as Medium Date in the
underlying query
Phil
"Ishbel Kargar" <ik@radmid.demon.co.uk> wrote in message
news:bq*******************@news.demon.co.uk... Dear Phil
Waste of time asking for subs from someone who has expired :-(
Thanks for your comment, quite logical I suppose, unless you know the
people I'm dealing with.
We are a small organisation and most of us know each other. Subs
reminders usually prompt an apologetic 'sorry I forgot to renew', together with a cheque!
The letter I gave as an example was just one of several mail-merge
letters, and I really do need help with the date format problem.
So I still hope someone can help with the problem.
Regards to all
Ishbel
"Phil Stanton" <di********@stantonfamily.co.uk> wrote in message
news:3f***********************@mercury.nildram.net ... Two thoughts
1) Is the Control Panel Regional and language Options set correctly
Yes, I've checked everything there, even deleted the option for USA format!
2) Might be worth trying to show the date Format as Medium Date in the underlying query
Tried this, even converted the 'expiry' field in the main table to 'medium
date format', but it hasn't solved the problem. The Members Form also now
has 'medium date format', but the mail merge still produces the 'expiry'
date in mm/dd/yy - I'm puzzled! Not looking forward to altering all the
letters by hand!
Ishbel
One last idea, Ishbel, after this I give up
Try
In your query for the mail merge try the date for your letter
DateOut: Format$([ExpireyDate],"dd\/mm\/yyyy")
I am assuming your table holding the ExpireyDate is defined as a Date/Time
and not text
Phil
"Ishbel Kargar" <ik@radmid.demon.co.uk> wrote in message
news:bq******************@news.demon.co.uk... "Phil Stanton" <di********@stantonfamily.co.uk> wrote in message news:3f***********************@mercury.nildram.net ... Two thoughts
1) Is the Control Panel Regional and language Options set correctly Yes, I've checked everything there, even deleted the option for USA
format! 2) Might be worth trying to show the date Format as Medium Date in
the underlying query
Tried this, even converted the 'expiry' field in the main table to 'medium date format', but it hasn't solved the problem. The Members Form also now has 'medium date format', but the mail merge still produces the 'expiry' date in mm/dd/yy - I'm puzzled! Not looking forward to altering all the letters by hand!
Ishbel
"Phil Stanton" wrote: One last idea, Ishbel, after this I give up Try In your query for the mail merge try the date for your letter DateOut: Format$([ExpireyDate],"dd\/mm\/yyyy")
I am assuming your table holding the ExpireyDate is defined as a Date/Time and not text
Phil
Dear Phil
I'm grateful for all your help, but I've finally solved the problem in a
completely different way.
I began to wonder if the problem was not with Access, but with Word, because
all the lists, labels, reports, etc. produced by Access showed the dates in
the UK format. And yes, all date fields were already set as Date/Time and
not as Text.
My new laptop has brought with it Word 2002, whereas all my reminder letters
were prepared using Word 2000. In spite of adjusting the date format in
Word 2002 to 'English UK format - dd/mm/yy' the problem persisted, so I took
the plunge, deleted Word 2002 (with some regret because I liked some of the
new facilities), and re-installed Word 2000 from my Office 200 Premium disk.
Hurray!! The date fields in the letters now show the dd/mm.yy format once
more and I can get on with my mailshot.
I did try your (one last try) suggestion before I took the drastic step
described above, and it was because that didn't work that I began to look at
the problem from a different angle, and realised that the culprit was Word
2002! My faith in Access has been restored!
Thanks again
Best wishes
Ishbel
All good fun.
You would have thought Microsoft would have got that right. Or do you know
them better?????
Phil
"Ishbel Kargar" <ik@radmid.demon.co.uk> wrote in message
news:bq*******************@news.demon.co.uk... "Phil Stanton" wrote:
One last idea, Ishbel, after this I give up Try In your query for the mail merge try the date for your letter DateOut: Format$([ExpireyDate],"dd\/mm\/yyyy")
I am assuming your table holding the ExpireyDate is defined as a
Date/Time and not text
Phil Dear Phil
I'm grateful for all your help, but I've finally solved the problem in a completely different way.
I began to wonder if the problem was not with Access, but with Word,
because all the lists, labels, reports, etc. produced by Access showed the dates
in the UK format. And yes, all date fields were already set as Date/Time and not as Text.
My new laptop has brought with it Word 2002, whereas all my reminder
letters were prepared using Word 2000. In spite of adjusting the date format in Word 2002 to 'English UK format - dd/mm/yy' the problem persisted, so I
took the plunge, deleted Word 2002 (with some regret because I liked some of
the new facilities), and re-installed Word 2000 from my Office 200 Premium
disk. Hurray!! The date fields in the letters now show the dd/mm.yy format once more and I can get on with my mailshot.
I did try your (one last try) suggestion before I took the drastic step described above, and it was because that didn't work that I began to look
at the problem from a different angle, and realised that the culprit was Word 2002! My faith in Access has been restored!
Thanks again
Best wishes Ishbel
Dear Phil All good fun.
I see your point, it does sound like good fun, though I was almost at my
wit's end, and didn't see it as funny as the days went by with no solution.
However, the fun side is definitely there, in the form of having solved yet
another problem, in my 'love-hate' relationship with my computer.
Especially as I was also trying to get help from my teenage grandson (who
knows 'everything there is to know' about computers?). It's given me quite
a buzz to be able to say that a 74 year old grandmother still has the edge!
You would have thought Microsoft would have got that right. Or do you know them better?????
I do now!
Thanks again
Regards
Ishbel This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: praba kar |
last post by:
Dear All,
I have doubt regarding date string to time
conversion function. In Python I cannot find flexible
date string conversion function like php strtotime. I
try to use following type...
|
by: William Wisnieski |
last post by:
Hi Everyone,
Access 2000
I have some code behind a button that performs a word merge with a query
data source. The merge works fine. But what I'd like to do somehow is
after the merge is...
|
by: Andy Davis |
last post by:
I have a table of data in Access 2002 which is used as the source table for
a mail merge document using Word 2002 on my clients PC. The data is
transferred OK but I've noticed that any dates which...
|
by: Reb |
last post by:
Hi,
How do i convert this "Sun Jun 29 00:00:00 UTC 0800 2003"
to the normal date format (mm/dd/yyyy).
Thanks
Reb
|
by: Sueffel |
last post by:
Having a small problem figuring out how to convert the following structures
to VB:
private struct RECT
{
public int left;
public int top;
public int right;
public int bottom;
|
by: Arno R |
last post by:
Hi all,
I have a database that I need to use in different versions of Access.
This is A97 in most places and A2k in a few other locations.
(I develop in A97 and convert the db to A2k for these...
|
by: scott |
last post by:
Hi Everyone,
I don't know if this is the correct forum but I thought i'd ask. I have an
access DB with a function to automatically safe a table with fields i'm mail
merging into MS Word. Word...
|
by: johnvon |
last post by:
I have a mail merge that runs flawlessly in Access 2000. In 2003 I keep
getting dialog boxes that I can't figure out how to supress. Several of them
are telling me that Admin (me!) has the database...
|
by: beechclose |
last post by:
I have an form in Access which runs a make-table query and then mail merges the contents to Word. One of the merged fields is a date - in Access the date appears in 'UK' format correctly but when...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |