Thanks - I understand - will save me a lot of typing. I have done programming for 30 years and still hunt n pick

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

Reply via email to