Making progress!
Am able to copy Marriage Address to the correct person, but can not delete (disconnect) from the Marriage Address - it stays the same. Column 12 in tblER is 0 for All entries, thus can not change to 0.
How else to remove Marriage Address?
Resigned to the fact I have to do each individually, rather than global. At least a one time deal for the 86 individuals.
When I worked for Armstrong World Industries, I went to Gothenberg and drove to Stockholm - beautiful. My neighbor is from Skar and one of my co workers now spends 80% of his time up North at the flooring plant. Small World.
Many thanks and I hope you can solve this last operation.
Jack
----- Original Message ----- From: "Christer Siverud" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, January 13, 2005 4:08 PM
Subject: RE: [LegacyUG] Print Marriage Address
OK a attempt to more detailed description
Open the database with access with suffix .fdb Open table tblAR = Addresses Column 1 "IDAR" is record ID Column 2 "Kind" have code 0 for personal address, 1 for eventaddress and 2 for archiveaddress. Find your imported marrigeaddresses with code 1 and change them to code 0 but make a note of the IDAR
- Here you found the IDAR 214-300
Open table tblIR = Individuals Column 25? "IDAR" is recordnumber for indivisual address. By putting an ID from tblAR here you connect the individual with the address. Change the 0 (zero) to the address record ID.
- Do a search for the indivudal you want to connect to an event. Lets say
you want to connect John Doe to event 214. Search for John and when you find
the record go to column IDAR in his record and enter 214. Now event 214 is
connected to John Doe. Repeat for all persons that should be connected to
the events 214-300.
Open table tblER = Events
Column 12 "IDAR" is the events address record ID.
Find the ID for the addresses you gave to individual and change to 0 (zero)
thereby disconnecting the address from the marriageevent.
Christer -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Kaufmann Sent: den 10 januari 2005 13:27 To: [email protected] Subject: Re: [LegacyUG] Print Marriage Address
OK to tblIR step. Then confused. "By putting an ID from tblAR here you connect.....Change the 0 to the address record ID."
My changes are for IDAR 214 to IDAR 300. Seems I can not do as block, rather
individually - is this correct? What is an ID as there is not one in tblAR -
or is it called something else?
Many thanks for your suggestion
Hope you can clarify above for me
Jack
----- Original Message ----- From: "Christer Siverud" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, January 03, 2005 2:19 PM Subject: RE: [LegacyUG] Print Marriage Address
betweenHi
This is what to do but MAKE BACKUP FIRST !!! You are changing links(zero)tables and might lose information !!! Do not blame me if that happens.
Open the database with access with suffix .fdb
Open table tblAR = Addresses
Column 1 "IDAR" is record ID
Column 2 "Kind" have code 0 for personal address, 1 for eventaddress and
2
for archiveaddress.
Find your imported marrigeaddresses with code 1 and change them to code 0
but make a note of the IDAR
Open table tblIR = Individuals
Column 25? "IDAR" is recordnumber for indivisual address. By putting an
ID
from tblAR here you connect the individual with the address. Change the 0
(zero) to the address record ID.
Open table tblER = Events
Column 12 "IDAR" is the events address record ID.
Find the ID for the addresses you gave to individual and change to 0thereby disconnecting the address from the marriageevent.
Good luck and be careful !
Christer
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Kaufmann Sent: den 2 januari 2005 17:37 To: [email protected] Subject: Re: [LegacyUG] Print Marriage Address
Perhaps I am not clearly stating what I need.
I have quite a few Marriage Addresses that are NOT Marriage Addresses - they were my mailing list from the Generations program. I want to translate them to the familly person for each family. No suggestions to date allow me to do this simply. I do not know all the people to create a tag for sorting.
From the print out, I will retype the addresses into the correct location.
I have asked several times of Legecy on how to change the database fields (I am proficient in MS-Access), but have gotten no response!!!
Hope this clarifies my need.
Many thanks for your help...Jack
----- Original Message ----- From: "Paula Ryburn" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, December 31, 2004 12:29 PM Subject: Re: [LegacyUG] Print Marriage Address
Master Lists > Address Lists > Mailing: Tag the marriage addresses you want to print (e.g., churches)
Reports > Address Labels > Who to Print: Event Addresses and check "Include only tagged addresses"
Of course, pick label size, sort, etc. I think that should work for you.
--Paula
on labels
thx
On labels? In reports?
--Paula
How to do this?
Jack
Legacy User Group Etiquette 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/
To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
Legacy User Group Etiquette 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/
To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
Legacy User Group Etiquette 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/
To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
Legacy User Group Etiquette 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/
To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
Legacy User Group Etiquette 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/
To unsubscribe please visit:
http://www.legacyfamilytree.com/LegacyLists.asp
Legacy User Group Etiquette 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/
To unsubscribe please visit: http://www.legacyfamilytree.com/LegacyLists.asp
