Hi Terry, Your Access work looks great to me, also. I too was wondering how to get this type of information out of Legacy - as is. It just isn't there. You certainly have a great idea here. I think you should approach Legacy for an Add-On. I myself am not experienced enough, I think, in Access to import your code since I haven't been in the ftb file itself yet...however, I think with some work on my part I would be successful...Thank goodness for backups!
I'd be happy to be an experimenter to attempt such an import and would be happy to report my results to you! At the very least, my husband who also is a software/hardware engineer would be at my side making sure I didn't make a beginners boo boo! Good luck with your approach to Legacy! Nan On Fri, Aug 26, 2011 at 9:27 PM, Jerry <[email protected]> wrote: > Hi Terry. I just took a look at your screen shots. Looks interesting. > I should mention that it appears as though all the embedded links you > have below go only to screen 4 when clicked on. I changed each one in > my browser address to screen1, screen2, and screen3 which enabled me to > view the other screens. I haven't done anything else other than look at > them, but I thought I would mention that to you. > > Thanks, > > Jerry - MerriamFamilyTree.org > > On 8/26/2011 7:57 PM, Terry Foster wrote: > > 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 > > <http://electricfoster.info/SourceDocs/LocationTamer/Screen4.jpg>) > > Show all events tied to a location > > (http://electricfoster.info/SourceDocs/LocationTamer/Screen2.jpg > > <http://electricfoster.info/SourceDocs/LocationTamer/Screen4.jpg>) > > List all child locations in a parent (All cities in a county) > > (http://electricfoster.info/SourceDocs/LocationTamer/Screen3.jpg > > <http://electricfoster.info/SourceDocs/LocationTamer/Screen4.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/[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 > > 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/[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 > 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/[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 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
