Home
Creators
Search Recent Random
Posts
Search DMs Popular Hash Lookup Tags Random
Importer
Import FAQ
Register Favorites Keys Review DMs Logout
Community
Telegram ThePornDude
Home Creators Posts Import Register Favorites Logout

Family Tree Maker Update [Gold & Silver] (Patreon)

Published:
2022-07-18 12:16:00
Imported:
2026-06

Videos

Downloads

Content

Hello Members!

In this week’s Feature, Fix, or Focus, we take last week’s Family Tree Maker training.

Here are the updates I made for this training:

· Ability To Add Siblings requested by Bent Lauridsen

Please don’t forget to add your requests for your own Feature, Fix or Focus each week when I post a new video, right here on Patreon. Each week I will either add a new feature, fix a bug or an issue, or create another training with a special focus on any part, all based on your feedback and comments.

Make sure to view the brand new and updated training and download the updated workbook in the attachments below.

Files

Vimeo

Join the web's most supportive community of creators and get high-quality tools for hosting, sharing, and streaming videos in gorgeous HD with no ads.

Comments

Mike Shellito

Thank you for the Family Tree Maker. I recently came across a need to do something along these lines and thought that Randy might have done something like this. Low and behold you had, great news. Bad news is I can get it to work. When I select a family member to move onto the Family Tree chart, I get a message box saying “Plase make sure to move the family member onto the family tree”, and the move fails. If I step through the macro, I can move the member before it checks the position of the shape, and it works. So what I need to know is how to programmably allow enough time to make the move? I am also having a problem deleting a member who is already on the chart, but my guess is that solving the above will solve this.

Excel For Freelancers

HI Mike, thanks for your comment and question. This makes perfect sense. In any of my Drag & Drop Training I add a counter such as Dim Counter as long For Counter = 1 to 100000 DoEvents 'Your Code here Next Counter The DoEvents allows you to do other things while the code is running, and this essentially ads a counter (or a certain amount of time) until the operation completes> I share an example of this in the Patreon Update of the Calendar Training here: https://www.patreon.com/posts/ultimate-update-89800221 I hope this helps and thanks so much.

Mike Shellito

Thanks for the quick response. I saw the counter and DoEvents, but the testing for “Incorrect Move” is within this loop, so there is really no time to make the move and the .left of the shape will always be that of its original position in column E, which is out of bounds. In the Calendar template you capture the original position of the shape to determine if it has moved, then test if it is a legal move. Unfortunately, I am not advanced enough to apply that to the Family Tree template.

Excel For Freelancers

Hi Mike, thanks so much for the comment. I have a training coming up in a week called 'Tree View control' in which may be easier to apply a family tree. I will be using it for Customers, Order Types & Invoices, and Items, however, you can use this for a family tree as well. I think its much more natural way of demonstrating relationships then the training above. I hope this helps and thanks so much.

Jan Troszczynski

How do we delete the family member(s) and clear the family to start our own new family tree?

Excel For Freelancers

Hi Jan, you can just delete the row from the database or you could add in a macro to do that simply by assigning a row and then using something like .Ranges(MembRow & ":" & MembRow).entireRow.Delete And then running the macro that refreshes the schedule. I hope this helps and thanks so much.