... Dennis, I modified the above code to "Tag individuals who HAVE a picture attached". It seems to work, did I do anything wrong? UPDATE tblIR SET...
232
Dennis Kowallek
kowallekfamily
Dec 2, 2010 1:20 pm
On Thu, 02 Dec 2010 04:19:51 -0000, "tractorlaird" <73fwd@...> ... Looks OK to me. Keep in mind that it will only tag people with an INDIVIDUAL picture...
233
Dennis Kowallek
kowallekfamily
Dec 11, 2010 8:16 pm
My wife bought a Win7/64 PC to replace her dinosaur. I have to set it up. I just spent 2 hours trying to figure out how to share a printer on the Win7/64 PC...
234
Ron Ferguson
ronfergy2000
Dec 11, 2010 8:23 pm
Have one for me, Dennis. See http://blogs.techrepublic.com.com/window-on-windows/?p=1910&tag=leftCol;post-3425 near the bottom of the page. Ron Ferguson ...
235
Dennis Kowallek
kowallekfamily
Dec 11, 2010 8:40 pm
On Sat, 11 Dec 2010 20:23:28 -0000, "Ron Ferguson" ... Done! The main problem is that when the XP/32 PC connects to the Win7/64 PC, it tries to find a 32-bit...
236
Wm
bellafortuni
Dec 12, 2010 8:17 pm
I am woefully ignorant of access. Would it be possible to write a query that would give a list of all people with Event X and all instances of it with D/P/D/N?...
237
Dennis Kowallek
kowallekfamily
Dec 12, 2010 8:22 pm
On Sun, 12 Dec 2010 20:17:57 -0000, "Wm" <bellafortuni@...> ... What is D/P/D/N? -- Dennis Kowallek (LTools) dennis@... ...
238
Wm
bellafortuni
Dec 12, 2010 8:32 pm
Sorry -- Description, Date, Place, Notes....
239
Dennis Kowallek
kowallekfamily
Dec 12, 2010 8:50 pm
On Sun, 12 Dec 2010 20:32:41 -0000, "Wm" <bellafortuni@...> ... You could tweak this... SELECT tblET.EventType, tblIR.IDIR AS RIN, tblIR.GivenName, ...
240
Dennis Kowallek
kowallekfamily
Dec 12, 2010 9:34 pm
On Sun, 12 Dec 2010 15:50:00 -0500, Dennis Kowallek <kowallek@...> ... Maybe change the sort order to... SELECT tblIR.IDIR AS RIN, tblET.EventType,...
241
Wm
bellafortuni
Dec 13, 2010 12:16 am
Worked a treat Dennis -- I even remembered how to reformat the dates. A couple hours spent cleaning up my event input errors and building the html and it's...
242
Dennis Kowallek
kowallekfamily
Dec 13, 2010 12:12 pm
On Mon, 13 Dec 2010 00:16:18 -0000, "Wm" <bellafortuni@...> ... Don't forget I wrote a VB function that you can use to reformat dates (if you have...
243
Wm
bellafortuni
Dec 13, 2010 3:13 pm
Yep, and it worked perfectly, too. Wm...
244
Wm
bellafortuni
Dec 15, 2010 4:09 pm
Using the query, I did a new sort for the event "Master", which records known apprenticeships. The generated csv is quite messy; notes are unpredictably broken...
245
Dennis Kowallek
kowallekfamily
Dec 15, 2010 4:28 pm
On Wed, 15 Dec 2010 16:09:06 -0000, "Wm" <bellafortuni@...> ... Send me (privately) the csv and the SQL statement used to generate it. Don't send the...
246
Dennis Kowallek
kowallekfamily
Dec 15, 2010 5:10 pm
On Wed, 15 Dec 2010 16:09:06 -0000, "Wm" <bellafortuni@...> ... You need to sort by more than just 1 column. Maybe 'ORDER BY tblIR.IDIR, tblER.Order'...
247
Wm Voss
bellafortuni
Dec 16, 2010 1:10 am
You are right about the CRLF; in addition to intended use, pasting copied text into notes adds them whether wanted or not. I did discover that if I open the...
248
mturner92
Dec 31, 2010 2:15 am
may I ask how best to automatically have my legacy file with media links eg "Grogan John 1864 Birth Cert.jpg" to "Grogan_John_1864_Birth Cert.jpg" 9without...
249
Dennis Kowallek
kowallekfamily
Dec 31, 2010 12:34 pm
On Fri, 31 Dec 2010 02:11:12 -0000, "mturner92" <mgrogan92@...> ... Do you have MS Access? -- Dennis Kowallek (LTools) dennis@... ...
250
Dennis Kowallek
kowallekfamily
Dec 31, 2010 1:20 pm
On Fri, 31 Dec 2010 02:11:12 -0000, "mturner92" <mgrogan92@...> ... Hi Margaret: If you have MS Access, run the following query in Access ... UPDATE...
251
mturner92
Jan 1, 2011 1:37 am
Thanks Dennis. Happy New Year to you. Thanks for Ltools and all the support ... Margaret...
252
Robert
smsgtbob
Jan 10, 2011 12:38 pm
Please advise if 'Delete Master Events' is the same as deleting a Master Source? The description in LTools leads me to believe I could use the feature to...
253
Dennis Kowallek
kowallekfamily
Jan 10, 2011 1:04 pm
... No, they are not the same thing. Master Events are listed when you go, in Legacy, to "View > Master Lists > Event Definition". The Master Event Definition...
254
Robert
smsgtbob
Jan 10, 2011 9:23 pm
Dennis - That makes sense, but I was hoping that there was a way to obercome this. If I 'edit' the Master Source and change it to the data I would like, it...
255
doit4ron
Feb 20, 2011 2:23 am
I have noticed that there are many alias names in my Legacy databases which are exactly equal to the main name. Is there an easy way to find all those...
256
doit4ron
Feb 20, 2011 2:40 am
For LDS users...is there a way to find all children who should have sealed to parents = BIC based on the time of their birth relative to the date their parents...
257
Dennis Kowallek
kowallekfamily
Feb 20, 2011 12:43 pm
On Sun, 20 Feb 2011 02:23:51 -0000, "doit4ron"; <doit4ron@...> ... Ron: Thanks for posting your question to this group so others can benefit. To display...
258
Dennis Kowallek
kowallekfamily
Feb 20, 2011 1:03 pm
On Sun, 20 Feb 2011 02:40:26 -0000, "doit4ron"; <doit4ron@...> ... Ron: Not being LDS, I don't know enough about the terminology here to be able to...
259
Dennis Kowallek
kowallekfamily
Feb 25, 2011 4:03 pm
Is anyone having problems with any LTools' dialogs appearing truncated on the right side (so the Run and Close buttons are not accessible)? -- Dennis Kowallek...
260
Evert van Dijken
evandijken
Feb 25, 2011 5:19 pm
No problems here (windows 7 64bit)Evert To: ltools@yahoogroups.com From: kowallek@... Date: Fri, 25 Feb 2011 11:03:00 -0500 Subject: [ltools] Dialogs...
