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