www.spansoft.org

I am intrigued that you can import 2638 people and their families and the families do no appear in the tree layout. People in limbo do not appear on the tree layout but any person linked to a family should be on the tree layout somewhere, or are all these people in limbo?

John Wood

Hi all, Here is a variation to the query I posted on the 14 May 2009 under the subject "List all references to a particular source document" First a recap on what I said then:- To give quick access to all references to a particular source document use the following query. The document code will be t...

I get the same results using the Families Tab search. It does work ok. as an SQL Query with partial match set. Try :- SELECT Families.[Description], Families.[Fathers name], Families.[Mothers name] FROM Families WHERE ( UPPER(Families.[Fathers name]) LIKE '%SMITH%' ) AND ( UPPER(Families.[Mothers na...

Hi all, Here is a query I use to list the picture description & file name for a specific set of pictures I have linked to my database. You could list all your pictures and filter the specific set by copying the list into a spreadsheet. First a bit of background as to how I set up my database. Under ...

Hi Nick, The Database Fields page of the help file needs updating now that pictures can be linked to Source Documents & Source References. I was trying to understand how the pictures database linked to source documents as well as People & Families. The Links / Notes fiels shows how the Record Code i...

Hi Nick, There is a problem with how the SQL query window formats a query when the query SELECT statement will not fit on one line. I select a database in SQL query, select none of the selected fields, then add fields until the number of selected fields causes the query to spill into a following lin...

Hi Nick,

Thanks for the info. I don't have any extra language keyboards installed but I notice that I can get the same options under "encoding" when I right-click in Windows Explorer. I have not yet discovered how to uninstall IME.

John Wood

Hi Nick, I like the Background Layer feature that is now available in 3.1. I found all the families that I have not moved to a named layer. I have also tried the Backup and Restore of the database. With a large database and lots of pictures the backup produced a ZIP file of 221Mb in ten minutes, the...

Hi Peter, I have just downloaded and installed 3.0.7 without any problems on Windows 7. I did however have problems installing the latest version of TreeDraw a week ago. This was due to the time taken to download the program. The download timed out before completion, Nick will know what the time lim...

Windows 7 Here's a strange one! Open a timeline or search box window. Minimize the window. Drag the minimized window from the lower left of the screen, off the top, left or right of the screen. A transparent copy of the minimized icon appears at the top left or right of the screen, not a major probl...

Hi John, I have also noted that the "Records Modified" date is not updated when I update any notes. When I remember, I bang the space bar in an empty field of the person or family record followed by the backspace key; this sets the "Records Modified" flag and then I can hit the [Update] key. I agree...

Hi Roger, To answer your question :- "Using privacy level as a classification is quite neat although I'm not quite sure how it is used. " In my example I said I recorded all 1861 census data with a privacy level of 9 to match RG9 from the Register General 9 filing system for all 1861 census data. I ...

Hi all, How do you record the information you transcribe from a census page? I have been looking at various Family History programs for ideas as to how census forms are recorded. I have not found a program that includes a census form. I want to record the transcription of a family on one note attach...

Hi Nick, After strugling to drag the picture, right clicking, rolling the mouse wheel, etc. I have now found the slide bars at the edge of the screen, so I can see the not visible area of the picture, egg on face then. Why didn't I notice them before? I spent too much time reading the help file rath...

Hi Nick, In Options -> Preferences -> Pictures -> Shrink large images to fit screen, if selected the image is shrunk to fit the screen. If this option is not selected then part of the image will not be visible. But in this situation it is not possible to move the picture so that the not visible part...