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] 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] 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] 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