Re: [LegacyUG] Hello from MyHeritage + 2 unique offers

2017-09-14 Thread Linda Yocum
The offer states: "exclusively to our Legacy users and webinar viewers."  Does 
this mean you have be a webinar subscriber as well as being a legacy user to 
get the discount?  I imagine this is still a very good  offer even if you don't 
have v9.

From: LegacyUserGroup  on behalf of CE 
WOOD 
Sent: Thursday, September 14, 2017 2:26 PM
To: Legacy User Group
Subject: Re: [LegacyUG] Hello from MyHeritage + 2 unique offers


Here is the latest from Geoff. The email with the offer was sent from Legacy 
News >. It 
just now arrived in my Inbox.

Geoff recommends emailing, but I found it much easier to call and explain. I 
also got a refund for the unused months of my Data and Site subscriptions.



Again, the MyHeritage world-wide toll-free phone list is at: 
https://www.myheritage.com/FP/contact-us.php



CE

Two Unique Offers for Legacy Users - Last Chance





Dear Legacy user,

Thousands of our users have already taken the 2 special offers by MyHeritage, 
given exclusively to Legacy users and webinar viewers. Due to high demand, we 
have extended the deadline of these offers, which are now valid through Monday 
night, September 18. This is your last chance to enjoy the offers.

Offer 1: Get a MyHeritage Complete Plan at 50% off

50% off of the MyHeritage Complete Plan. PLUS: A Price-Lock Guarantee. The 
discounted price of $125/year will remain the same and will never increase in 
the future (as long as you keep your subscription active)! Since you are 
already a MyHeritage subscriber, to add an extra year of this plan at 50% off 
and secure the valuable Price Lock Guarantee, please follow these steps:

- Send an email to 
legacy...@myheritage.com
- include the email address you use to login to MyHeritage
- include your phone number

and a MyHeritage team member will give you a quick call to arrange the 
transaction with the Price Lock Guarantee. They'll also give you a deduction of 
the unused amount of your current subscription. Because there are different 
memberships that you might have (Premium, PremiumPlus, Data, Complete) we 
aren't able to send one blanket email to everyone AND ensure that everyone's 
special pricing would be correct.

See - I told you that you would love this!

Just be sure that you do send the email before Monday night, September 18 to 
secure the discounted offer. This is a unique offer that MyHeritage is giving 
only to Legacy users and webinar viewers.

This Complete Plan offer includes everything MyHeritage has to offer: 
PremiumPlus family site with unlimited tree size, powerful matching to other 
family trees and historical records, and full search access to their collection 
of more than 8.1 billion historical records. This also provides full access to 
all the Record Matches and Smart Matches that appear in your Legacy 9 software. 
All this for just $125 – that’s 50% off the public price.

Offer 2: MyHeritage DNA Kit - Only $59 $99

- Click 
HERE
 to purchase your DNA kit(s)

- IMPORTANT: At Checkout, under “Total,” click “Got a coupon code?” and enter 
the coupon code LEGACYDNA. This is the only way to enjoy the special discount.

Both offers are given at the lowest price ever offered by MyHeritage, 
exclusively to our Legacy users and webinar viewers. Hurry, these offers expire 
on Monday night, September 18.








From: LegacyUserGroup 
>
 on behalf of Dave Keeney >
Sent: Thursday, September 14, 2017 9:52 AM
To: Legacy User Group
Subject: Re: [LegacyUG] Hello from MyHeritage + 2 unique offers



Just an FYI to current subscribers trying to get the deal. I was also able to 
do it but it wasn't as easy as indicated.



When I called they told me that it was only for new subscribers. I explained 
some of the messages on this board but he said there were only 10 reps and no 
one was giving the deal to existing users. That might be why some people are 
saying they can't get the deal.



He then said he'd check with his manager. After a long wait he came back saying 
he was able to do it. He apologized profusely and was able to get it 
accomplished.



So just be warned that all of the reps may not know yet. So if at first you 
don't succeed try, try, again.
-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


Re: [LegacyUG] How to query in 7.5

2017-08-16 Thread Linda Yocum
Patricia,

I have v8, so I hope it is the same.  Go to 'Reports', 'Statistics Report', and 
the 'Family File Statistics' window will open.  The third one down is 'Longest 
Living Individuals' listed by century.  Happy birthday to your uncle and I hope 
he wins!

Linda


From: LegacyUserGroup  on behalf of 
Margaret Turner 
Sent: Wednesday, August 16, 2017 8:25:56 PM
To: Legacy User Group
Subject: Re: [LegacyUG] How to query in 7.5

If you are willing to plunge into the world of SQL !!!
I am of no help in SQL :(
here is a working example from Ltools (now free) which works only in Legacy 7 
(hence my dependence on 7.5) http://zippersoftware.com/wp/
https://groups.yahoo.com/neo/groups/ltools/conversations/topics/1022

Finding persons died under age 15
SELECT IDIR, BirthD, DeathD, DateValue(Mid([BirthD],5,2) & "/" &
Mid([BirthD],3,2) & "/" & Mid([BirthD],7,4)) AS BirthDate,
DateValue(Mid([DeathD],5,2) & "/" & Mid([DeathD],3,2) & "/" &
Mid([DeathD],7,4)) AS DeathDate INTO tempAges
FROM tblIR
WHERE ((IDIR<>0) AND (BirthD Like "00*") AND (DeathD Like "00*") AND
((Mid([BirthD],3,2))<>"00") AND ((Mid([BirthD],5,2))<>"00") AND
((Mid([DeathD],3,2))<>"00") AND ((Mid([DeathD],5,2))<>"00"));

I do this just to make the next query easier to read.

SELECT IDIR, BirthD, DeathD, DateDiff("",[BirthDate],[DeathDate]) AS
Age INTO tblAges FROM tempAges;



On 17 August 2017 at 10:11, Evelyn .. 
> wrote:
That only looks at birth year. If someone were born in 1926 and died in 1927 
they would still show up on that list, but they aren't over 90 yrs old.

If you look at birth year before 1927 AND death year is blank then you'd get 
all the people who are still alive and 90+. It would also pick up all those 
people who don't have a death date entered yet because it isn't known. It would 
miss those born before 1927 and lived 90+ years before dying.

The person has to be born in 1926 or earlier and either still be alive (no 
death date) or they died after they turned 90 (death year minus birth year).

Since age is a calculated amount and I don't know how to do that in Legacy, you 
might have to do a separate search for:
1) those who were born before 1927 and are still alive (death date blank)
2) then for each year before 1927
birthdate before 1926 AND deathdate after 2016
birthdate before 1925 AND deathdate after 2015... etc

- Evelyn

On Wed, Aug 16, 2017 at 4:28 PM, Mark 
> wrote:
Patricia,

 It wouldn’t matter whether you have Legacy 7.5, 8 or 9; this procedure works 
for all Legacy versions.
 Your Uncle is going to 90, therefore, he was born in 1927
 Using Search > Find
 Look for Whom: Individual
Where to Look: Birth Date
How to Look: Before
What to Look For: 1927
 Second Condition : AND
 Look for Whom: Individual
Where to Look: Birth Date
How to Look: After
What to Look For: 1926
 This will find anyone in your database who is born for the whole year of 1926, 
because whole year dates are taken from 1 Jan to 31 Dec.
In my database, the above returned 8 individuals.

 If I changed the first What condition to 17 Aug 1927, and left the second What 
condition as is, I will increase this to 19, as it will include everyone 
between 1 Jan 1926 AND 17 Aug 1927.
Easy.


Kind Regards,Mark

From: LegacyUserGroup 
[mailto:legacyusergroup-boun...@legacyusers.com]
 On Behalf Of Patricia Kruger
Sent: Thursday, 17 August 2017 6:44 AM
To: legacyusergroup@legacyusers.com
Subject: [LegacyUG] How to query in 7.5

I am using Legacy 7.5.  I want to find out who in my database has lived longer 
than my 'soon-to-be 90 year old- uncle.  So how do I query the data to identify 
individuals who have lived 90 years or more.  Thanks.

-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


Re: [LegacyUG] Which report?

2016-03-07 Thread Linda Yocum






 
Thanks so much to all of you who replied.  
 
Apparently, I did not create a webpage on the internet by just following Mike 
Bigley's instructions.  What I "created" was really fantastic and very 
useful---but I kinda did panic thinking all my unfiltered info was out on the 
World Wide Web for all to see!
As well as this thread, I also contacted Legacy Support and got this very, very 
quick answer:   When you create a web page through Legacy all the information 
is stored in a folder on your computer.  Just go delete this folder.By default 
this folder is located at C-Drive>Legacy>web for Legacy 7.5.

Sincerely,
 Jairmie
 Technical Support
 Legacy Family TreeI did delete the folder---and I think I'll just stick to the 
trusty LFT program and leave the "web" stuff alone!!! From: 
rgstrongge...@gmail.com
To: legacyusergroup@legacyusers.com
Date: Mon, 7 Mar 2016 15:31:23 -0500
Subject: Re: [LegacyUG] Which report?







Linda,
If you just created it it is not on the web unless you uploaded it to a 
site. All it has done is created the webpages on your site and you have to view 
them on your local computer with internet browser. The only time they will be 
on 
the actual internet is if you uploaded them there.
Russ


 

From: Linda Yocum 
Sent: Monday, March 07, 2016 11:21 AM
To: Legacy User Group 
Subject: Re: [LegacyUG] Which report?
 

HELP!!!  I 
created a web page as per Mike Bigley's instructions.  It looks fantastic, 
but how do I go about deleting it from the internet?  I should have done a 
lot of editing and deleting of info first! 
 

> To: legacyusergroup@legacyusers.com
> From: 
sarlesinsi...@gmail.com
> Date: Sun, 6 Mar 2016 15:50:12 -0500
> 
Subject: Re: [LegacyUG] Which report?
> 
> Thanks to everyone for 
the many possibilities to get the report I need. 
> All are good and 
workable ideas and I look forward to accomplishing my goal.
> 
> 
What a great group of folks here! So kind to help when needed.
> 
> 
Jane S.
> 
> On 3/5/2016 12:21 AM, Steve Hayes via LegacyUserGroup 
wrote:
> 
> 
> -- 
> 
___
> LegacyUserGroup mailing 
list
> LegacyUserGroup@legacyusers.com
> To manage your subscription 
and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com



-- 
___
LegacyUserGroup 
mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription 
and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com


-- 
___
LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com

  -- 
___
LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com


Re: [LegacyUG] Which report?

2016-03-07 Thread Linda Yocum
HELP!!!  I created a web page as per Mike Bigley's instructions.  It looks 
fantastic, but how do I go about deleting it from the internet?  I should have 
done a lot of editing and deleting of info first! 
 
> To: legacyusergroup@legacyusers.com
> From: sarlesinsi...@gmail.com
> Date: Sun, 6 Mar 2016 15:50:12 -0500
> Subject: Re: [LegacyUG] Which report?
> 
> Thanks to everyone for the many possibilities to get the report I need.  
> All are good and workable ideas and I look forward to accomplishing my goal.
> 
> What a great group of folks here!  So kind to help when needed.
> 
> Jane S.
> 
> On 3/5/2016 12:21 AM, Steve Hayes via LegacyUserGroup wrote:
> 
> 
> -- 
> ___
> LegacyUserGroup mailing list
> LegacyUserGroup@legacyusers.com
> To manage your subscription and unsubscribe 
> http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
  -- 
___
LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com