RE: [LegacyUG] How to merge a basic source into ESM template source using Access

Richard, I had a look at this to see if it would work in OpenOffice. In principle it should, although the syntax of the query is quite different - anyone who uses OOo should be able to convert it without difficulty. Unfortunately I was unable to verify whether the procedure works in OOo.

Re: [LegacyUG] How to merge a basic source into ESM template source using Access

Richard Van Wasshnova wrote Using Access we can manually change a basic TemplateID to match that of the ESM source we want to merge it to. Richard, thank you *so much* for these instructions. I think they may save me a *great deal* of time. But how frustrating that they arrive on the day I

Re: [LegacyUG] How to merge a basic source into ESM template source using Access

Thank you very much Richard. Appreciate it. Jeff - Original Message - From: Richard Van Wasshnova rfvanwasshn...@gmail.com To: LegacyUserGroup@legacyfamilytree.com Sent: Tuesday, June 09, 2009 10:29 PM Subject: [LegacyUG] How to merge a basic source into ESM template source using

RE: [LegacyUG] How to merge a basic source into ESM template source using Access

Do not attempt to edit your Family File in Access without first doing a backup of the Family File! Thanks for using Legacy. Sherry Customer Support Millennia Corporation supp...@legacyfamilytree.com http://www.LegacyFamilyTree.com We are changing the world of genealogy! When replying to

RE: [LegacyUG] How to merge a basic source into ESM template source using Access

Be sure to back up the Family File before making any changes to it in Access or OO. Thanks for using Legacy. Sherry Customer Support Millennia Corporation supp...@legacyfamilytree.com http://www.LegacyFamilyTree.com We are changing the world of genealogy! When replying to this message,

RE: [LegacyUG] How to merge a basic source into ESM template source using Access

Richard, This is a jewel. I tried it out and it works great! Thank you for choosing Legacy, Jim Terry Technical Support Legacy Family Tree Legacy Charting http://LegacyFamilyTree.com Phone: 425 788-0932 We are changing the world of genealogy! -Original Message- From:

Re: [LegacyUG] How to merge a basic source into ESM template source using Access

Although I have both Access and OO database, I have no experience of using either programme - it simply hasn't proved relevant to my computer needs. Is it possible that this method of combining sources will be available in Legacy at any time? -- - - - - - - - Elizabeth researching ALLAMBRIDGE

[LegacyUG] How to merge a basic source into ESM template source using Access

In L7 after vers. 55 sources to be merged must have the same source templateID, (tblSR TemplateID). Basic TemplateID = 0 and ESM source template IDs are positive integers. Using Access we can manually change a basic TemplateID to match that of the ESM source we want to merge it to. In Legacy: Tag

Re: [LegacyUG] How to merge a basic source into ESM template source using Access

Richard, Thank you for the detailed instructions. At this late hour, they seem a bit daunting, but I will definitely hang onto them. --Paula in Texas --- On Tue, 6/9/09, Richard Van Wasshnova rfvanwasshn...@gmail.com wrote: From: Richard Van Wasshnova rfvanwasshn...@gmail.com Subject: