[LegacyUG] Tags showing
Perhaps I have been sleeping or something - but I just notices that all of the TAGS (1-9) show up in the Individual Information screen (at the bottom right). VERY HANDY! Good Move LEGACY!!! Thanks Keith -- Surnames: McKain, Horn, Riale, Ulrich, Erisman, Leiphart, Reed and Henry Website: http://home.comcast.net/~geosci64 EMail: geosc...@gmail.com McCain-McKane-O'Kane DNA Group 1 Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] Creating Books
Alastair, Thank you for your response. I am not ready to publish as yet. I am still trying to determine what should go in the book and what type of charts to use. It is difficult to create a readable chart with more than 4 generations on a single standard size page. An ancestor chart or pedigree chart can easily span several generations with continuations to other pages, but that does not work very well with descendant charts. I am looking for a way to create a descendant chart in multiple pages suitable for a book. Another possible way to reduce the size of a descendant chart would be to show direct descendants only. Chick On Fri, Aug 21, 2009 at 1:16 AM, Alastair Lack wrote: > Chick, > I've done quite a few books through www.lulu.com - a first class > publishing arrangement that is very inexpensive. > I use a multiple lines of descent report, and include a quarter fan so > that the originators of all the lines can be traced. > The Legacy pdf has a first class layout, much easier than trying to > print a rtf and then modifying it in MS Word, in my opinion. To make > it compatible with Lulu, I re-print it and at that stage include the > charts etc. where I want them. > There are lots of pdf creation software products out there - I use the > Adobe one for which Lulu have a downloadable print settings file. > Good luck > Alastair > > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > Archived messages: > http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ > Online technical support: http://www.LegacyFamilyTree.com/Help.asp > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > > > > Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] Table Usage & Access
Have you tried this? Options>customize>Other "Custom User ID Numbers" This option creates and automatically fills in a custom user ID number containing the RIN number and optional text. This ID number can be placed in all User ID fields or just those that are currently empty. If you would like to first remove all existing user IDs, click the Clear All User IDs button. To apply your custom number to the selected fields, click Apply. Phil Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] Table Usage & Access
On Fri, 21 Aug 2009 17:34:09 -0400, SgtBob wrote: >Dennis et al - I don't know how to make it any plainer - I want to change the >File Detail ID number from 1234-1 to 9876-01. I would like to use Access to >enter 9876-01 in lieu of 12340-1 in the 'File Ref' field or whichever table >this will work on. I woiuykld liek to do it this way so I can see if I >covered all of the changes I need to make. My attempt to change it by opening >one of my saved .fdb files in Access, then using the tblSX, making the changes >and then when I exited Access and opened the .fdb file, the changes did not >occur - so. If this explanation doesn't cover it, I'll move on. Just another thought... Have you looked at doing this in Legacy with Search & Replace? It will do the same thing and you won't have to deal with SQL. -- Dennis Kowallek (LTools) http://zippersoftware.com/ltools http://groups.yahoo.com/group/ltools Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] Table Usage & Access
On Fri, 21 Aug 2009 17:34:09 -0400, SgtBob wrote: >Dennis et al - I don't know how to make it any plainer - I want to change the >File Detail ID number from 1234-1 to 9876-01. I would like to use Access to >enter 9876-01 in lieu of 12340-1 in the 'File Ref' field or whichever table >this will work on. I woiuykld liek to do it this way so I can see if I >covered all of the changes I need to make. My attempt to change it by opening >one of my saved .fdb files in Access, then using the tblSX, making the changes >and then when I exited Access and opened the .fdb file, the changes did not >occur - so. If this explanation doesn't cover it, I'll move on. Bob: Based on your explanation... If you want to replace all occurrences of "1234-1" with "9876-1" in tblSX.FilingRef ... UPDATE tblSX SET tblSX.FilingRef = "9876-1" WHERE tblSX.FilingRef = "1234-1" You will be replacing all instances of your old FilingRef with the new FilingRef. Can you see the problem this might cause? What if you already had an old FilingRef of "9876-1"? Unless you are doing something to insure this won't happen, I would recommend the following... UPDATE tblSX SET tblSX.FilingRef = "NEW 9876-1" WHERE tblSX.FilingRef = "1234-1" You can always go back later and get rid of the "NEW " prefix after your re-filing effort is complete. About my pestering you for details... The phrase "mass changes" can mean a lot of things. Anything from the explanation you gave above ... to "change all File IDs to the current MRIN while retaining the -number suffix at the end of the old File ID". The answer we give you depends on extracting the correct requirements. To be honest with you, I wouldn't describe your request as a "mass change". You still will need to run the query one FilingRef at a time, which could be quite time consuming. HTH -- Dennis Kowallek (LTools) http://zippersoftware.com/ltools http://groups.yahoo.com/group/ltools Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] Table Usage & Access
SgtBob, You can email me direct at lask...@att.net Send me a screenshot of the window of the level that you want the file ref changed. You do this by making sure that window is highlighted in Legacy, hold down the ALT key and then hit the Print Screen key. Next, click on the edit paste button in your email software -- or do a CTL-V to paste. Like Dennis, I need to know if you want every person in your database that has a source, to have the file id be reflected with the RIN number followed by a sequence number? Valerie -Original Message- From: k...@legacyfamilytree.com [mailto:k...@legacyfamilytree.com] On Behalf Of SgtBob Sent: Friday, August 21, 2009 4:34 PM To: LegacyUserGroup@legacyfamilytree.com Cc: Valerie Laskowski Subject: RE: [LegacyUG] Table Usage & Access Dennis et al - I don't know how to make it any plainer - I want to change the File Detail ID number from 1234-1 to 9876-01. I would like to use Access to enter 9876-01 in lieu of 12340-1 in the 'File Ref' field or whichever table this will work on. I woiuykld liek to do it this way so I can see if I covered all of the changes I need to make. My attempt to change it by opening one of my saved .fdb files in Access, then using the tblSX, making the changes and then when I exited Access and opened the .fdb file, the changes did not occur - so. If this explanation doesn't cover it, I'll move on. =I Valerie Laskowski wrote: > The "FilingRef" field is in BOTH tblSX and tblSR tables. Double check at > which level that you entered the text for "FileID". > > If you "Edit Master Source" and want it on that screen -- then use tblSR. > > If you "Edit Detail" and want it on that screen -- then use tblSX. > > Valerie > > -Original Message- > From: k...@legacyfamilytree.com [mailto:k...@legacyfamilytree.com] On Behalf > Of Dennis M. Kowallek > Sent: Friday, August 21, 2009 7:42 AM > To: LegacyUserGroup@legacyfamilytree.com > Subject: Re: [LegacyUG] Table Usage & Access > > On Fri, 21 Aug 2009 5:27:28 -0400, SgtBob wrote: > > >A couple of suggestions I received indicated that I was on the right > tract that might permit me to change them in tblSX using Access - > unfortunately, I have discovered that even if I change the 'Filing REF' > data, the change doesn't 'take' in my 'bob.fdb' file when I re-opened it in > Legacy. > > Then my guess is that you updated the wrong row in tblSX. tblSX is a > tricky devil. See ... > > http://zippersoftware.com/ltools/help/v1/tblSX_Type.htm > > ... for more info on the tblSX.Type column and how it relates to > tblSX.IDIME. > > Since it appears that you may have updated the wrong rows, I hope you > restored your database back to where it was before you made the Access > updates. > > >Any suggestions on a method to do mass changes to Detail File ID's when in > Access? > > Sure. I can write a very simple UPDATE query that will change every File > ID in your database to "Fred Flintstone". But I don't think that's what > you want! > > Do you mean change every occurrence of "1234-5" to "9876-4"? Give us > some detailed requirements and we can tell you if it is possible. Lay it > out logically so we don't have to guess what you mean. > > -- > > Dennis Kowallek (LTools) > http://zippersoftware.com/ltools > http://groups.yahoo.com/group/ltools > > > > Legacy User Group guidelines: >http://www.LegacyFamilyTree.com/Etiquette.asp > Archived messages: >http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ > Online technical support: http://www.LegacyFamilyTree.com/Help.asp > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > > > > > > > Legacy User Group guidelines: >http://www.LegacyFamilyTree.com/Etiquette.asp > Archived messages: >http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ > Online technical support: http://www.LegacyFamilyTree.com/Help.asp > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > > > -- /Users/robertrunion/Desktop/eMail Icons/signature.pdf Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] Table Usage & Access
Dennis et al - I don't know how to make it any plainer - I want to change the File Detail ID number from 1234-1 to 9876-01. I would like to use Access to enter 9876-01 in lieu of 12340-1 in the 'File Ref' field or whichever table this will work on. I woiuykld liek to do it this way so I can see if I covered all of the changes I need to make. My attempt to change it by opening one of my saved .fdb files in Access, then using the tblSX, making the changes and then when I exited Access and opened the .fdb file, the changes did not occur - so. If this explanation doesn't cover it, I'll move on. =I Valerie Laskowski wrote: > The "FilingRef" field is in BOTH tblSX and tblSR tables. Double check at > which level that you entered the text for "FileID". > > If you "Edit Master Source" and want it on that screen -- then use tblSR. > > If you "Edit Detail" and want it on that screen -- then use tblSX. > > Valerie > > -Original Message- > From: k...@legacyfamilytree.com [mailto:k...@legacyfamilytree.com] On Behalf > Of Dennis M. Kowallek > Sent: Friday, August 21, 2009 7:42 AM > To: LegacyUserGroup@legacyfamilytree.com > Subject: Re: [LegacyUG] Table Usage & Access > > On Fri, 21 Aug 2009 5:27:28 -0400, SgtBob wrote: > > >A couple of suggestions I received indicated that I was on the right > tract that might permit me to change them in tblSX using Access - > unfortunately, I have discovered that even if I change the 'Filing REF' > data, the change doesn't 'take' in my 'bob.fdb' file when I re-opened it in > Legacy. > > Then my guess is that you updated the wrong row in tblSX. tblSX is a > tricky devil. See ... > > http://zippersoftware.com/ltools/help/v1/tblSX_Type.htm > > ... for more info on the tblSX.Type column and how it relates to > tblSX.IDIME. > > Since it appears that you may have updated the wrong rows, I hope you > restored your database back to where it was before you made the Access > updates. > > >Any suggestions on a method to do mass changes to Detail File ID's when in > Access? > > Sure. I can write a very simple UPDATE query that will change every File > ID in your database to "Fred Flintstone". But I don't think that's what > you want! > > Do you mean change every occurrence of "1234-5" to "9876-4"? Give us > some detailed requirements and we can tell you if it is possible. Lay it > out logically so we don't have to guess what you mean. > > -- > > Dennis Kowallek (LTools) > http://zippersoftware.com/ltools > http://groups.yahoo.com/group/ltools > > > > Legacy User Group guidelines: >http://www.LegacyFamilyTree.com/Etiquette.asp > Archived messages: >http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ > Online technical support: http://www.LegacyFamilyTree.com/Help.asp > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > > > > > > > Legacy User Group guidelines: >http://www.LegacyFamilyTree.com/Etiquette.asp > Archived messages: >http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ > Online technical support: http://www.LegacyFamilyTree.com/Help.asp > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > > > -- /Users/robertrunion/Desktop/eMail Icons/signature.pdf Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] Reports Questions/Capabilities
In regards to your #3, Special Text Entry: 1. It needs to list the either all or the 1st so many characters, just like the place holder does, so that you will know which special text it is. This should probably get turned in to Mantis. 2. It is a RTF file. So when you create, do a File save as and then name the file. You can always use another Text editor for your formatting, but make sure you save it as a RTF. 3. For special pages between generations -- that is what the "place holder" feature is for. I use it for pictures that I generate in another product. You just tell Legacy how many pages will be there and it will increase the page number count for the following page so that you can insert your other pages. Play around with more and read up on the documentation. There are good features that are not really obvious until to you until you have generated a book a few times and tries various options. I use the sample.fdb to do this. Valerie _ From: k...@legacyfamilytree.com [mailto:k...@legacyfamilytree.com] On Behalf Of James Sweet Sent: Friday, August 21, 2009 1:45 PM To: LegacyUserGroup@legacyfamilytree.com Subject: [LegacyUG] Reports Questions/Capabilities Greetings, I have some of questions that perhaps someone in the group can help me with. I'm using the reports Publishing Center to put together a book for an 80 year old aunt. I'm including a Pedegree Chart, a Descendent Narrative Book (5 generations) and an Ancestor Book Report (15 generations). I want to include a family lore story, a few pertinent historical articles, and a couple of pages that include images. 1. I initially wanted to use the Special Text Entry options (for the text only items), but cannot find a way to adjust the font or layout of those pages. When I click on "Edit Settings" the page looks exactly as I want it. However, when I do a Preview or Print, those pages end up all left-justified and in the standard report font. Is there any way to fix this? Or do I need to instead do the "Place Holder" option and print out the special pages separately and insert them after printing the book? 2. Further on the Special Text Entry options: On the Publishing Center setup page these are listed in the Chapter list. However, no title is shown, just "Special Text Entry:." Since I have several of these items, that makes it difficult to keep the order of them straight. Only way I've found is to do the Preview, then look at the Table of Contents page. Time consuming. (Note that the "Place Holder" option does display the title for that page...) 3. I'd like to connect my historical items to the appropriate generation/person. Is there a way to put a "special page" between, say, generation 8 and generation 9 in the Ancestor Book? I could do it after printing the book by physically putting the extra pages in the desired location, but then the page numbering would not be consistent. 4. One more: As for inserting other extra items into a book or a report it would nice if there were an option to add a link to a Word file, or graphics file, or what have you. Better yet, to put a copy of the desired page or document right into the report. Thank you for any help or ideas you can provide. Regards, Jim Sweet email: jimls38...@gmail.com Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] Fwd: Search Problem
-Original Message- From: Jenny M Benson To: LegacyUserGroup@LegacyFamilyTree.com Sent: Tue, Aug 11, 2009 2:47 am Subject: Re: [LegacyUG] Fwd: Search Problem Pat Patton wrote Second Request Any ideas? In this instance there have already been some answers to your query, I believe, but - addressing myself not only to you, Pat - may I point out that if a question elicits *no* response from LUGgers it is probably because no one has a solution. Thank goodness we don't have everyone writing in saying "Sorry, I don't know"! One can always check the archives to be sure a post has been received and whether there have been replies which have not been seen for whatever reason. -- Jenny M Benson Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] Table Usage & Access
The "FilingRef" field is in BOTH tblSX and tblSR tables. Double check at which level that you entered the text for "FileID". If you "Edit Master Source" and want it on that screen -- then use tblSR. If you "Edit Detail" and want it on that screen -- then use tblSX. Valerie -Original Message- From: k...@legacyfamilytree.com [mailto:k...@legacyfamilytree.com] On Behalf Of Dennis M. Kowallek Sent: Friday, August 21, 2009 7:42 AM To: LegacyUserGroup@legacyfamilytree.com Subject: Re: [LegacyUG] Table Usage & Access On Fri, 21 Aug 2009 5:27:28 -0400, SgtBob wrote: >A couple of suggestions I received indicated that I was on the right tract that might permit me to change them in tblSX using Access - unfortunately, I have discovered that even if I change the 'Filing REF' data, the change doesn't 'take' in my 'bob.fdb' file when I re-opened it in Legacy. Then my guess is that you updated the wrong row in tblSX. tblSX is a tricky devil. See ... http://zippersoftware.com/ltools/help/v1/tblSX_Type.htm ... for more info on the tblSX.Type column and how it relates to tblSX.IDIME. Since it appears that you may have updated the wrong rows, I hope you restored your database back to where it was before you made the Access updates. >Any suggestions on a method to do mass changes to Detail File ID's when in Access? Sure. I can write a very simple UPDATE query that will change every File ID in your database to "Fred Flintstone". But I don't think that's what you want! Do you mean change every occurrence of "1234-5" to "9876-4"? Give us some detailed requirements and we can tell you if it is possible. Lay it out logically so we don't have to guess what you mean. -- Dennis Kowallek (LTools) http://zippersoftware.com/ltools http://groups.yahoo.com/group/ltools Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
RE: [LegacyUG] Reports Questions/Capabilities
James, I have never looked at this feature before, so I thought I would have a go. I only used the features available ie. I did not put any other codes in such as center, indent, etc. When looking at the Preview all the settings are there. I did not print (no ink - again!). I could not see a way of changing the font size or style for this specific feature. Regarding your other points I do not think they are available. I have said many times on this list that Legacy does not have a word processor and only allows basic rtf styling. Post processing in Word, OpenOffice or any PDF editor is probably necessary for book reports IMO. This, I think, is how it should be. Ron Ferguson _ Tutorials: Programme of adding videos commenced http://www.fergys.co.uk/ View the Grimshaw Family Tree at: http://www.fergys.co.uk/Grimshaw/ For The Fergusons of N.W. England See: http://myweb.tiscali.co.uk/fergys/ _ > Date: Fri, 21 Aug 2009 11:45:29 -0700 > Subject: [LegacyUG] Reports Questions/Capabilities > From: jimls38...@gmail.com > To: LegacyUserGroup@legacyfamilytree.com > > Greetings, > > > > I have some of questions that perhaps someone in the group can help me with. > > > > > > I’m using the reports Publishing Center to put together a book for an 80 year > old aunt. > > > I’m including a Pedegree Chart, a Descendent Narrative Book (5 generations) > and an Ancestor Book Report (15 generations). I want to include a family lore > story, a few pertinent historical articles, and a couple of pages that > include images. > > > > > > > 1. I initially wanted to use the Special Text Entry options (for the text > only items), but cannot find a way to adjust the font or layout of those > pages. When I click on “Edit Settings” the page looks exactly as I want it. > However, when I do a Preview or Print, those pages end up all left-justified > and in the standard report font. Is there any way to fix this? Or do I need > to instead do the “Place Holder” option and print out the special pages > separately and insert them after printing the book? > > > > > > > 2. Further on the Special Text Entry options: On the Publishing Center setup > page these are listed in the Chapter list. However, no title is shown, just > "Special Text Entry:." Since I have several of these items, that makes it > difficult to keep the order of them straight. Only way I’ve found is to do > the Preview, then look at the Table of Contents page… Time consuming. (Note > that the "Place Holder" option does display the title for that page...) > > > > > > 3. I’d like to connect my historical items to the appropriate > generation/person. Is there a way to put a “special page” between, say, > generation 8 and generation 9 in the Ancestor Book? I could do it after > printing the book by physically putting the extra pages in the desired > location, but then the page numbering would not be consistent. > > > > > 4. One more: As for inserting other extra items into a book or a report it > would nice if there were an option to add a link to a Word file, or graphics > file, or what have you. Better yet, to put a copy of the desired page or > document right into the report. > > > > > Thank you for any help or ideas you can provide. > > > > Regards, > > Jim Sweet > > email: jimls38...@gmail.com > > > _ Windows Live Messenger: Happy 10-Year Anniversary—get free winks and emoticons. http://clk.atdmt.com/UKM/go/157562755/direct/01/ Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
[LegacyUG] Reports Questions/Capabilities
Greetings, I have some of questions that perhaps someone in the group can help me with. I’m using the reports Publishing Center to put together a book for an 80 year old aunt. I’m including a Pedegree Chart, a Descendent Narrative Book (5 generations) and an Ancestor Book Report (15 generations). I want to include a family lore story, a few pertinent historical articles, and a couple of pages that include images. 1. I initially wanted to use the Special Text Entry options (for the text only items), but cannot find a way to adjust the font or layout of those pages. When I click on “Edit Settings” the page looks exactly as I want it. However, when I do a Preview or Print, those pages end up all left-justified and in the standard report font. Is there any way to fix this? Or do I need to instead do the “Place Holder” option and print out the special pages separately and insert them after printing the book? 2. Further on the Special Text Entry options: On the Publishing Center setup page these are listed in the Chapter list. However, no title is shown, just "Special Text Entry:." Since I have several of these items, that makes it difficult to keep the order of them straight. Only way I’ve found is to do the Preview, then look at the Table of Contents page… Time consuming. (Note that the "Place Holder" option does display the title for that page...) 3. I’d like to connect my historical items to the appropriate generation/person. Is there a way to put a “special page” between, say, generation 8 and generation 9 in the Ancestor Book? I could do it after printing the book by physically putting the extra pages in the desired location, but then the page numbering would not be consistent. 4. One more: As for inserting other extra items into a book or a report it would nice if there were an option to add a link to a Word file, or graphics file, or what have you. Better yet, to put a copy of the desired page or document right into the report. Thank you for any help or ideas you can provide. Regards, Jim Sweet email: jimls38...@gmail.com
Re: [LegacyUG] Table Usage & Access
On Fri, 21 Aug 2009 5:27:28 -0400, SgtBob wrote: >A couple of suggestions I received indicated that I was on the right tract >that might permit me to change them in tblSX using Access - unfortunately, I >have discovered that even if I change the 'Filing REF' data, the change >doesn't 'take' in my 'bob.fdb' file when I re-opened it in Legacy. Then my guess is that you updated the wrong row in tblSX. tblSX is a tricky devil. See ... http://zippersoftware.com/ltools/help/v1/tblSX_Type.htm ... for more info on the tblSX.Type column and how it relates to tblSX.IDIME. Since it appears that you may have updated the wrong rows, I hope you restored your database back to where it was before you made the Access updates. >Any suggestions on a method to do mass changes to Detail File ID's when in >Access? Sure. I can write a very simple UPDATE query that will change every File ID in your database to "Fred Flintstone". But I don't think that's what you want! Do you mean change every occurrence of "1234-5" to "9876-4"? Give us some detailed requirements and we can tell you if it is possible. Lay it out logically so we don't have to guess what you mean. -- Dennis Kowallek (LTools) http://zippersoftware.com/ltools http://groups.yahoo.com/group/ltools Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] Using Access to Change Data
On Fri, 21 Aug 2009 5:12:35 -0400, SgtBob wrote: >Dennis - I have not been able to use your suggestion - mostly because I >couldn't figure out where to start. I am certainly not comfortable with >Access, except to view and some items and then export to an Excel spreadsheet >for further actions. At the risk of appearing dumber than I am, could you >show me hgow to start the formula you described in your earlier message? Disclaimer: I won't be responsible for any damage to your database. Proceed at your own risk... 1) Tag only the individuals you wish to update. 2) Backup your Legacy database and close Legacy. 3) Open your Legacy database in Access 4) Go to Create Query Design (how you get here depends on your version of Access - use Access Help if necessary) 5) Close the Show Tables dialog. 6) Go to SQL View (again, how you get here depends on your version of Access - use Access Help if necessary) 7) Paste the UPDATE query into the blank SQL window, making sure to change the tag and the cemetery name to the ones you want. 8) Click Run! Click Yes/OK when prompted to make the changes. 9) Close Access. 10) Open Legacy and verify your changes. If not what you expected, restore your Legacy database from the backup you created earlier. If you don't feel comfortable doing this than don't! Just make sure you have a good backup and that you know how to restore from a backup before proceeding!!! -- Dennis Kowallek (LTools) http://zippersoftware.com/ltools http://groups.yahoo.com/group/ltools Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] Table Usage & Access
SgtBob wrote A couple of suggestions I received indicated that I was on the right tract that might permit me to change them in tblSX using Access - unfortunately, I have discovered that even if I change the 'Filing REF' data, the change doesn't 'take' in my 'bob.fdb' file when I re-opened it in Legacy. If you have made changes to a Family File using Access and then open *the same* file in Legacy, the changes you have made *must* be reflected there. I had what appeared to be the same situation as you a little while ago. I used Save As to make a "backup" copy of my Legacy file (with a different name) before making changes to the original file in Access. I made the changes and re-opened Legacy and - as it is set to do - Legacy automatically opened the last-used file which was, of course, the newly-named Save As copy. When you open Legacy after the Access changes make sure you have the right Legacy Family File open - the same one you made the changes in with Access! -- Jenny M Benson Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
[LegacyUG] Table Usage & Access
A few weeks back, I indicated that I needed to change all my filing numbers because of a problem encountered after importing a GEDCOM file - i.e., I did not check the appropriate box of 'retain RIN and MRIN numbers' and all my Detail File ID numbers were changed in error and I need to renumber them. A couple of suggestions I received indicated that I was on the right tract that might permit me to change them in tblSX using Access - unfortunately, I have discovered that even if I change the 'Filing REF' data, the change doesn't 'take' in my 'bob.fdb' file when I re-opened it in Legacy. Any suggestions on a method to do mass changes to Detail File ID's when in Access? Note: These errors were only detected after several weeks of data entry and my backups are not the original backup with the former Detail File ID numbers. Changing them one at a time is very labor intensive, plus I am not certain if I have fixed all the changes I need to make. Bob -- /Users/robertrunion/Desktop/eMail Icons/signature.pdf Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
[LegacyUG] Using Access to Change Data
Dennis - I have not been able to use your suggestion - mostly because I couldn't figure out where to start. I am certainly not comfortable with Access, except to view and some items and then export to an Excel spreadsheet for further actions. At the risk of appearing dumber than I am, could you show me hgow to start the formula you described in your earlier message? Bob On Wed, 5 Aug 2009 15:54:05 -0500, RUNION ROBERT wrote: >Dennis - Is there anyway to use ACCESS to populate the burial address >to all those buried in a specific cemetery? I find after viewing the >suggestions here that I have a lot of folks I know are buried in a >specific cemetery, but it would take a lot of key strokes to get this >data into my file if I can not do so via Access. Please advise. Yes. It shouldn't be too difficult. Something like... UPDATE tblAR, tblIR SET tblIR.IDARBuried=[tblAR]![IDAR] WHERE ((tblIR.IDARBuried=0) AND (tblIR.IDIR<>0) AND (tblIR.Tag1=1) AND (tblAR.AddrName="XYZ Cemetery")) ... sets the Burial Address to XYZ Cemetery for anyone on Tag #1 who does not already have a Burial Address. This was done quick & dirty so it may require more testing. The usual caveat re backing up your database before doing anything in Access applies. ;-) -- Dennis Kowallek (LTools) http://zippersoftware.com/ltools http://groups.yahoo.com/group/ltools Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
Re: [LegacyUG] Creating Books
Chick, I've done quite a few books through www.lulu.com - a first class publishing arrangement that is very inexpensive. I use a multiple lines of descent report, and include a quarter fan so that the originators of all the lines can be traced. The Legacy pdf has a first class layout, much easier than trying to print a rtf and then modifying it in MS Word, in my opinion. To make it compatible with Lulu, I re-print it and at that stage include the charts etc. where I want them. There are lots of pdf creation software products out there - I use the Adobe one for which Lulu have a downloadable print settings file. Good luck Alastair Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp