Search found 224 matches

by Little.auk
14 Dec 2021 19:30
Forum: General Usage
Topic: Fact based queries
Replies: 9
Views: 1347

Re: Fact based queries

Hi Mike, I created custom IDs when I was using Legacy Family Tree many years ago, and have carried it on through Family Tree Maker and now into FH. They are as familiar to me as names are, so I also use them when naming Media files. It keeps file names short, but also identifies who they relate to. ...
by Little.auk
14 Dec 2021 13:50
Forum: General Usage
Topic: Fact based queries
Replies: 9
Views: 1347

Re: Fact based queries

Thanks Mike, A simple cut - paste - edit job and the query is working! I am using the All Facts query as my custom template and I want to sort \ Filter by Individual. I couldn't use FactOwner name, as there are loads of duplicated names in my tree ( e.g. Twelve William Rollins). Custom ID was the ob...
by Little.auk
14 Dec 2021 11:37
Forum: General Usage
Topic: Fact based queries
Replies: 9
Views: 1347

Fact based queries

I am trying to get to grips with FACT based queries, but am having problems working out how to insert "Individual" data, in particular I am trying to include a Custom ID (i.e. equivalent of %INDI.REFN% in an individual query). For Individual queries I have been able to build the expressions I need b...
by Little.auk
13 Dec 2021 16:09
Forum: General Usage
Topic: Access Lost to all Queries
Replies: 8
Views: 1273

Re: Access Lost to all Queries

Hi Mike,

Just to close this one out, thanks for your help. I have recreated the Directory Junctions and used a more meaningful folder name in OneDrive this time.

All is working as expected.
by Little.auk
13 Dec 2021 13:07
Forum: General Usage
Topic: Access Lost to all Queries
Replies: 8
Views: 1273

Re: Access Lost to all Queries

Thanks Mike - that is the answer! Now you have jogged my memory - I had to do that to be able to synchronise FH between my PC and Laptop. At the age of 75 it is hard to remember what you had for tea last Friday, let alone what you did six months ago! Looks like I need to do it again to repair the li...
by Little.auk
13 Dec 2021 11:10
Forum: General Usage
Topic: Access Lost to all Queries
Replies: 8
Views: 1273

Re: Access Lost to all Queries

I use a Wacom pen tablet in preference to a mouse, and on occasion have accidently dragged something to where it shouldn't be in documents, this is the first time I have done it with a folder. The C:\ProgramData folder was not involved in this dragging, all of my "User" files including OneDrive are ...
by Little.auk
12 Dec 2021 20:38
Forum: General Usage
Topic: Access Lost to all Queries
Replies: 8
Views: 1273

Re: Access Lost to all Queries

Hi Mike, I am not sure if there is still something funny going on. I have just installed the Backup and Restore plugin, and re-installed Ancestral Sources. They are both working, but as well as appearing in the ProgramData plugin data folder the ".DAT" files are also appearing in a Plugin Data folde...
by Little.auk
12 Dec 2021 19:48
Forum: General Usage
Topic: Access Lost to all Queries
Replies: 8
Views: 1273

Re: Access Lost to all Queries

Hi Mike, Thanks for the information. I have checked in the ProgramData folders, and found three "shortcuts" called Plugin, Queries, and Reports, that I don't think should be there. None of them took you anywhere, so I took a risk and deleted them. Everything else looked O.K., except that the Custom ...
by Little.auk
12 Dec 2021 12:48
Forum: General Usage
Topic: Access Lost to all Queries
Replies: 8
Views: 1273

Access Lost to all Queries

Hi All, I am running FH (Windows) version 7.0.9, my project files are all on OneDrive. This morning I have lost access to all queries. The last time a ran a query was a couple of days ago, and everything was working. I have changed nothing, but this morning the "QUERY" drop down on the ribbon is giv...
by Little.auk
10 Dec 2021 19:50
Forum: General Usage
Topic: Images rotated in Family Group Sheet report.
Replies: 4
Views: 819

Re: Images rotated in Family Group Sheet report.

Before I resorted to image cropping, or reducing resolution, I tried the "rotating image" fix suggested in "Common image problems", but it didn't work. I think that it is just the large file size that is overwhelming the report generator, as I have done a close comparison of the properties of files ...
by Little.auk
10 Dec 2021 13:54
Forum: General Usage
Topic: Images rotated in Family Group Sheet report.
Replies: 4
Views: 819

Images rotated in Family Group Sheet report.

Hi, I have been running the "Family Group Sheet ( for Web, CD or DVD)" report and have experienced a problem with some of the images. In the first Group Sheet I created (for my Paternal Grandfather) there were scanned images of four "old style" BMD certificates. These were all certificates that I ha...
by Little.auk
09 Dec 2021 10:36
Forum: General Usage
Topic: Assessment of a relationship rather than a fact
Replies: 8
Views: 1612

Re: Assessment of a relationship rather than a fact

I like Hannings graphics idea - I adopted a similar technique using the attached image on my Ancestry Tree, to "Flag" children who had died very young.
by Little.auk
16 Nov 2021 13:49
Forum: Ancestral Sources
Topic: Adoption template for AS
Replies: 1
Views: 674

Adoption template for AS

My wife was adopted at birth, quite late in life she decided to find her birth mother. As a result I now have her birth certificate and have used AS to create a source for her birth with her certificate image attached. I now want to create a source for her adoption. "Adoption" doesn't appear as one ...
by Little.auk
16 Nov 2021 10:52
Forum: General Usage
Topic: Ancestor/Ahnentafel number
Replies: 33
Views: 10736

Re: Ancestor/Ahnentafel number

Valid point! - So far I have created three versions of the query, filtered for Births, Marriages and Deaths. The Birth and Death queries appear to be working with a single column. For the Marriage query I have added two additional columns, to show spouse's name and spouse's Ahnentafel number. Compar...
by Little.auk
15 Nov 2021 12:32
Forum: General Usage
Topic: Ancestor/Ahnentafel number
Replies: 33
Views: 10736

Re: Ancestor/Ahnentafel number

Thanks Mike, I think one column will do, I want to use the Ahnentafel number to filter and sort Direct Line ancestors, and keep track of my progress on creating sources and linking media files. When I was using Family Tree Maker I used an Excel spreadsheet, but the Query facilities of FH mean I can ...
by Little.auk
15 Nov 2021 10:42
Forum: General Usage
Topic: Ancestor/Ahnentafel number
Replies: 33
Views: 10736

Re: Ancestor/Ahnentafel number

Thanks Mike,

One final question - how do I modify the Ahnentafel expression to work with a FACT based query?

I am trying to create a custom version of the "All Events" query with Ahnentafel Numbers
by Little.auk
14 Nov 2021 12:52
Forum: General Usage
Topic: Ancestor/Ahnentafel number
Replies: 33
Views: 10736

Re: Ancestor/Ahnentafel number

Thanks Mike, It is working perfectly, both in the property box and in my custom Ahnentafel query. I have one question however - in my custom query, in both the standard Ahnentafel number column and the AN0000 column, the characters display as grey text, why is this and is it possible to display them...
by Little.auk
14 Nov 2021 10:38
Forum: General Usage
Topic: Ancestor/Ahnentafel number
Replies: 33
Views: 10736

Re: Ancestor/Ahnentafel number

I have added the "=combine text" expression to my property box - is there a way that I can format the Ahnentafel number to with leading zeros so that it is four character long, so that if I remove the space after the "AN " it will display as "AN0001"
by Little.auk
12 Nov 2021 19:29
Forum: General Usage
Topic: Query Expression to display "preferred" marriage data
Replies: 13
Views: 2429

Re: Query Expression to display "preferred" marriage data

This is an interesting thread guys, but all I am reading is that the simple task of selecting a preferred spouse in a query is not possible, and although a marriage can be set as "preferred" there is no simple way of using this in a query. This means that, because Emma Smith is William Rollin's seco...
by Little.auk
11 Nov 2021 20:29
Forum: General Usage
Topic: Query Expression to display "preferred" marriage data
Replies: 13
Views: 2429

Re: Query Expression to display "preferred" marriage data

I am relatively new to FH, and have not yet looked at fact based queries. I am using an Individual query, I basically took the "Individuals with ID" standard query and built on that as a custom query. I have separate columns for Birth, Marriage and Death, and the query expressions for Births and Dea...
by Little.auk
11 Nov 2021 16:03
Forum: General Usage
Topic: Sorting a Query by Ahnentafel Number.
Replies: 7
Views: 1997

Re: Sorting a Query by Ahnentafel Number.

Rather than think "Blank" think "Empty" - an empty field contains nothing, a field with a space will contain the Character Code "32" for a space. They might display the same on screen, but they are definitely not the same in computer code. I have worked with computers since my university days (mid 1...
by Little.auk
11 Nov 2021 13:44
Forum: General Usage
Topic: Query Expression to display "preferred" marriage data
Replies: 13
Views: 2429

Query Expression to display "preferred" marriage data

Hi, I am trying to build a custom query to display the media records linked to Birth, Marriage and Death events for my ancestors. The expressions %INDI.BIRT[1].OBJE[1]>% and %INDI.DEAT[1].OBJE[1]>% work for Births and Deaths, but I have a problem with Marriages, because some ancestors married more t...
by Little.auk
07 Nov 2021 20:21
Forum: General Usage
Topic: Sorting a Query by Ahnentafel Number.
Replies: 7
Views: 1997

Re: Sorting a Query by Ahnentafel Number.

Hi Guys, Thanks for your responses. I am already using the filter option in another "Direct Line Only" query, but, for this particular query, I need to show both direct line and non-direct line people. I had thought of using Numberif to fill blanks with a large number like 999, (which would be an ac...
by Little.auk
02 Nov 2021 21:07
Forum: General Usage
Topic: Sorting a Query by Ahnentafel Number.
Replies: 7
Views: 1997

Sorting a Query by Ahnentafel Number.

I have a custom query for all Individuals where one of the fields is the Ahnentafel Number. This query is set to sort records in ascending order by Ahnentafel Number. The expression I am using is "=AhnentafelNumber(["Root"],%INDI%,1)", with sort set to ascending. This works (almost!), Ahnentafel Num...