Search found 224 matches
- 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. ...
- 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...
- 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...
- 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.
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.
- 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...
- 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 ...
- 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...
- 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 ...
- 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...
- 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 ...
- 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...
- 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.
- 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 ...
- 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...
- 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 ...
- 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
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
- 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...
- 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"
- 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...
- 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...
- 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...
- 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...
- 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...
- 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...