To convert a Burial Address to a Burial Location... 1) Clear all Address Tags. I don't think Legacy has a way to do this (other than one at a time), so you can...
58
Richard Van Wasshnova
vanwasshnova
Sep 3, 2009 11:27 pm
I edited UpdateQueries.txt by adding 2 queries: "Search and Replace missing multimedia after renaming (picture)","UPDATE tblBR SET tblBR.PicName =...
59
Dennis Kowallek
kowallekfamily
Sep 3, 2009 11:35 pm
On Thu, 3 Sep 2009 16:27:13 -0700, Richard Van Wasshnova ... What version of LTools? If you have 1.1.14, you should be adding your own queries to ...
60
Richard Van Wasshnova
vanwasshnova
Sep 4, 2009 5:56 am
I save my census images in subdirectories by Year/State/County/Township. I haven't been consistent in naming files. Lately I've been renaming files more...
61
Dennis Kowallek
kowallekfamily
Sep 4, 2009 11:53 am
On Thu, 3 Sep 2009 22:56:06 -0700, Richard Van Wasshnova ... Two comments... 1) Each line in the file should be in the form: "Title","Query" The fact that your...
62
Dennis Kowallek
kowallekfamily
Sep 4, 2009 2:03 pm
On Thu, 3 Sep 2009 22:56:06 -0700, Richard Van Wasshnova ... I think I grasp what you are saying (sometimes I'm a little slow before my 3rd cup of coffee). In...
63
Dennis Kowallek
kowallekfamily
Sep 5, 2009 3:46 pm
To create an Ahnentafel event for everyone in your ancestor line... 1) In Legacy, clear everyone on a tag you are not using. Let's use Tag8 in this example. 2)...
64
Richard Van Wasshnova
vanwasshnova
Sep 6, 2009 4:08 pm
Dennis, You said you probably would not add a query to rename pictures because you believe Legacy can do that from the Picture Center. I take it you have not...
65
Dennis Kowallek
kowallekfamily
Sep 6, 2009 4:40 pm
On Sun, 6 Sep 2009 09:07:07 -0700, Richard Van Wasshnova ... I had not, but I just did. Legacy V6 will rename the actual image *AND* update the row(s) in tblBR...
66
Richard Van Wasshnova
vanwasshnova
Sep 9, 2009 5:11 pm
I like the way I can Right click on "Raw" to bring up both "UpdateQueries" and "MyUpdateQueries" with a line separating. When I Right click on Custom Select...
67
Dennis Kowallek
kowallekfamily
Sep 9, 2009 5:36 pm
On Wed, 9 Sep 2009 10:10:07 -0700, Richard Van Wasshnova ... You have extra spaces in the "," separator. Correct them to: "Sort SR by SrcName to get...
68
Richard Van Wasshnova
vanwasshnova
Sep 9, 2009 7:08 pm
... Thanks! Took care of that "bug". ... Thanks again. No need for a simple sorting query then. ... OK but I'm staying at the shallow end of the pool. ... ...
69
Dennis Kowallek
kowallekfamily
Sep 9, 2009 7:38 pm
On Wed, 9 Sep 2009 12:07:20 -0700, Richard Van Wasshnova ... Yes. Sub-selects are a little more advanced. But if you do it in steps it's not that difficult....
70
Dave Miller
hajn0wka
Sep 12, 2009 12:24 am
Dear Dennis, First of all, thanks for giving us Ltools and for your continued excellent support. Two I use frequently are 'Set Individual User ID's' and 'Tidy ...
71
Dennis Kowallek
kowallekfamily
Sep 12, 2009 12:38 am
On Sat, 12 Sep 2009 12:24:11 +1200, "Dave Miller" <david@...> ... You are welcome. ... It appears that the info is stored in tblIR.Relations in a...
72
Dave Miller
hajn0wka
Sep 12, 2009 3:22 am
Dear Dennis, I'd seen that column and thought it couldn't possibly contain all the required information and, therefore, wasn't the one. I'll have to see if I ...
Dear Dennis, Thanks for that. I'm at work now so can't look at the tables but the one I saw called 'Relations' only contained either a 0, 1, or 2. I'll have to...
75
Dennis Kowallek
kowallekfamily
Sep 14, 2009 7:12 pm
... Ah hah! In Legacy V7 they did something different. I can't help you with that one. -- Dennis Kowallek (LTools) dennis@... ...
76
Dennis Kowallek
kowallekfamily
Sep 14, 2009 7:28 pm
... Apparently they now put the relationships in the *.Rel file, which is just another Jet database. But I'll be damned if I can figure out what it means! -- ...
77
david
hajn0wka
Sep 14, 2009 9:52 pm
Dear Dennis, I had a look at that file and if you don't understand it then I've got no chance! Thanks for having a look anyway. I would have liked to have...
78
Dennis Kowallek
kowallekfamily
Sep 16, 2009 2:18 am
I was asked off-list: "how might I "muck with the database" to reset the "next MRIN to use" field" The answer is: UPDATE tblMR SET...
79
Evert van Dijken
evandijken
Sep 16, 2009 11:23 am
Hi Dennis, Sending this private because of the screenshot (I don’t know if attachments are allowed in the Ltools user group) I’m new to Ltools and am...
80
Dennis Kowallek
kowallekfamily
Sep 16, 2009 11:58 am
On Wed, 16 Sep 2009 13:21:33 +0200, Evert van Dijken ... Evert: Merge Basic to SourceWriter essentially just flips the switch on the Master Source record to...
81
Evert van Dijken
evandijken
Sep 16, 2009 12:58 pm
"Item of Interest" was called "Source Detail" in the basic source system. That's where I put the page numbers etc. And in my family file of over 30.000...
82
Evert van Dijken
evandijken
Sep 16, 2009 1:47 pm
I just had another look at a couple of different SourceWriter sources and saw that "Source Detail" is not only "Item of Interest" but also "Certificate type",...
83
Dennis Kowallek
kowallekfamily
Sep 16, 2009 1:55 pm
On Wed, 16 Sep 2009 15:46:23 +0200, Evert van Dijken ... I think this was the whole point of why Legacy never released a conversion tool. People do there...
84
Ron Ferguson
ronfergy2000
Sep 16, 2009 2:49 pm
Dennis, Both yourself and Evert are correct. The LTools conversion is a straight forward conversion from Basic to Source Writer style, and produces exactly the...
85
Richard Van Wasshnova
vanwasshnova
Sep 19, 2009 10:49 pm
I wrote an Update Query for ltools to tag marriages that use a particular source: "Tag marriage records (on tag 1 to 9) that use a selected Source (View tblSR,...
86
Dennis Kowallek
kowallekfamily
Sep 19, 2009 11:06 pm
On Sat, 19 Sep 2009 15:47:58 -0700, Richard Van Wasshnova ... I'll think about this. In the meantime, can you give an example? ... Actually, if you refresh...
