Hi Maybe it is not column 12, I only have 10 fingers for calculations. The important is to find the column called "IDAR". That is where the number you should change to 0
Christer -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Kaufmann Sent: den 14 januari 2005 06:05 To: [email protected] Subject: Re: [LegacyUG] Print Marriage Address 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 > > >>> Hi >>> >>> This is what to do but MAKE BACKUP FIRST !!! You are changing links >> between >>> 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 0 >> (zero) >>> thereby 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 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
