Thank you, Richard. Regards,
Jennifer http://colston-wenck.com -----Original Message----- From: Richard Van Wasshnova [mailto:[email protected]] Sent: Wednesday, 24 November 2010 6:34 PM To: [email protected] Subject: Re: [LegacyUG] Source Writer source to Basic using MS Access Jennifer, Nothing to it. First, of course, Backup. Tag the Source Writer Source that you want converted to Basic and untag all others. Run the following select query: SELECT tblSR.IDSR, tblSR.SrcName, tblSR.Contents, tblSR.UseStandard, tblSR.TemplateID, tblSR.SrcTag, tblSX.IDIME, tblSX.Type, tblSX.SrcDetail, tblSX.SrcDetText, tblSX.SrcDetNote, tblSX.Content FROM tblSR INNER JOIN tblSX ON tblSR.IDSR = tblSX.IDSR WHERE (((tblSR.SrcTag)=1)); This will show you all the citations using that Master Source. Under UseStandard, change the first record from zero (0) to one (1). The rest of them will change too when you move cursor down to next record. Under TemplateID, change the number there to zero (0). The rest of them will change too when you move cursor down to next record. If you keep track of the TemplateID you can even change it back with no loss of data. The query could be simpler or even more automated but thought you might want to see all citations. Good luck. -- Richard Van Wasshnova On Mon, Nov 22, 2010 at 5:00 AM, Jennifer Crockett <[email protected]> wrote: > Using MS Access, can anyone tell me how to convert a Source Writer source to > a Basic source and then merge the two so that the Source Detail is > preserved? > > Regards, > > Jennifer > http://colston-wenck.com Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
