Hi Dennis,
Thank you for the bad news. Are you saying I could have access put the
marriage date into the picture date but it just would not change format as
the regular Legacy dates do. If so I could live with that. If someone can
show me how to do marriages I think I could adapt it for baptisms and deaths
also.
Richard
----- Original Message -----
From: "Dennis Kowallek" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, May 01, 2006 10:50 AM
Subject: Re: [LegacyUG] change Legacy dates using Access
On Mon, 01 May 2006 09:17:58 -0700, "Richard Van Wasshnova"
<[EMAIL PROTECTED]> wrote:
I would appreciate if someone could help me create an update query to get
the marriage date into the picture date, preferably as aflexible formatted
date
As you have discovered, the date in tblBR is not stored in the same
fashion as other Legacy dates. I don't know if there is a reason for
this ... a programmer will have to respond.
The tblBR date gets stored as a text field based on the Date Format
setting at the time the date is entered. Changing your Date Format later
does not affect dates already in tblBR. But if you go in later and
change the date in Legacy it will store the updated date in whichever
Date Format is currently selected.
So, in a nutshell, to do what you want as "a flexible formatted date" is
not possible.
--
Dennis M. Kowallek
[EMAIL PROTECTED]
Enter the drawing for a FREE Legacy Cruise to Alaska or a FREE research trip to
Salt Lake's Family History Library. Open to users of Legacy 6 Deluxe. Enter
online at http://legacyfamilytree.com/FreeTrip.asp
Legacy User Group guidelines can be found at:
http://www.LegacyFamilyTree.com/Etiquette.asp
To find past messages, please go to our searchable archives at:
http://www.mail-archive.com/legacyusergroup%40mail.millenniacorp.com/
For online technical support, please visit
http://www.legacyfamilytree.com/Help.asp
To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp