I will play with this when I return home. As someone who has worked in IT, could I reinforce that any time you do anything non-mainstream to a Legacy or any other database, always backup first and work with copy. Joan
On 28 Aug 2011, at 11:50, RICHARD SCHULTHIES <fourpa...@verizon.net> wrote: > I have forgotten most of my access programming after 15 years of not working > in it daily. One request I have made in the past to Legacy programmers (and > others), is to revamp the location concept. At present it goes from smallest > to biggest in four fields, then has five extra fields in their own order. My > desire is for all nine to be smallest to largest. Either direction. Example: > some people have 'hinted' at 5 or 6 files for German and British. Some places > only use 2 or 3 fields, and cannot be stretched. I sent this privately in L5, > L6 and L7. I have not seen any program that does locations in the desired > manner. The other overhaul would be to change the organization ( I have > forgotten the programming language so will hopefully understand my ideas > instead.) > Currently, there are 3 (forgot the name) 'superfields' "Surname, Given name > and RIN. The fourth field would be a sort ALL dates tool. It would grab all > BMD dates, along with events and chronologies. If the program could do this, > it would be mpressive. > Rich in LA CA > > --- On Fri, 8/26/11, Terry Foster <tfost...@kc.rr.com> wrote: > > From: Terry Foster <tfost...@kc.rr.com> > Subject: [LegacyUG] location Tamer > To: LegacyUserGroup@LegacyUsers.com > Date: Friday, August 26, 2011, 4:57 PM > > I'm a developer by trade and am fairly adept at Microsoft Access. I love > Legacy but I have found all genealogy software sorely lacking in the ability > to manage locations and do research on locations in the database. > > Since Legacy uses MS Access as a back-end I decided to add a form and some > code to do what I have always felt all genealogy software should do. I would > like someone to vet this work before I submit it to Legacy as a suggested > enhancement. Please let me know if you are interested. > > Here's a few things this form does: > > Displays all location data. > (http://electricfoster.info/SourceDocs/LocationTamer/Screen1.jpg) > Show all events tied to a location > (http://electricfoster.info/SourceDocs/LocationTamer/Screen2.jpg) > List all child locations in a parent (All cities in a county) > (http://electricfoster.info/SourceDocs/LocationTamer/Screen3.jpg) > Browse to google maps for each location > (http://electricfoster.info/SourceDocs/LocationTamer/Screen4.jpg) > > I have made a user guide, of > sorts:http://electricfoster.info/SourceDocs/LocationTamer/LocationTamer.pdf > > These features, coupled with the ability to quickly edit and standardize > locations in a database, are essential to me. I'm just so happy I can make > it work in Legacy. I thought I would share. > > You will need to know how to import a form and a VBA module into an Access > database in order to use this. > > Please don't attempt this unless you know your way around an Access database > and please, always back up your data before trying something like this. I > just may not be as good as I think I am! > > Terry > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > Archived messages after Nov. 21 2009: > http://www.mail-archive.com/legacyusergroup@legacyusers.com/ > Archived messages from old mail server - before Nov. 21 2009: > http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ > Online technical support: http://www.LegacyFamilyTree.com/Help.asp > Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on > our blog (http://news.LegacyFamilyTree.com). > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp > > > Legacy User Group guidelines: > http://www.LegacyFamilyTree.com/Etiquette.asp > Archived messages after Nov. 21 2009: > http://www.mail-archive.com/legacyusergroup@legacyusers.com/ > Archived messages from old mail server - before Nov. 21 2009: > http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ > Online technical support: http://www.LegacyFamilyTree.com/Help.asp > Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on > our blog (http://news.LegacyFamilyTree.com). > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp