Re: [LegacyUG] Using Access to Change Data

[Dennis M . Kowallek]

On Fri, 21 Aug 2009 5:12:35 -0400, SgtBob  wrote:

>Dennis - I have not been able to use your suggestion - mostly because I 
>couldn't figure out where to start.  I am certainly not comfortable with 
>Access, except to view and some items and then export to an Excel spreadsheet 
>for further actions.  At the risk of appearing dumber than I am, could you 
>show me hgow to start the formula you described in your earlier message?

Disclaimer: I won't be responsible for any damage to your database.
Proceed at your own risk...

 1) Tag only the individuals you wish to update.
 2) Backup your Legacy database and close Legacy.
 3) Open your Legacy database in Access
 4) Go to Create Query Design (how you get here depends on your version
of Access - use Access Help if necessary)
 5) Close the Show Tables dialog.
 6) Go to SQL View (again, how you get here depends on your version
of Access - use Access Help if necessary)
 7) Paste the UPDATE query into the blank SQL window, making sure to
change the tag and the cemetery name to the ones you want.
 8) Click Run! Click Yes/OK when prompted to make the changes.
 9) Close Access.
10) Open Legacy and verify your changes. If not what you expected,
restore your Legacy database from the backup you created earlier.

If you don't feel comfortable doing this than don't! Just make sure you
have a good backup and that you know how to restore from a backup before
proceeding!!!
 
-- 

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

[LegacyUG] Using Access to Change Data

[SgtBob]

Dennis - I have not been able to use your suggestion - mostly because I 
couldn't figure out where to start.  I am certainly not comfortable with 
Access, except to view and some items and then export to an Excel spreadsheet 
for further actions.  At the risk of appearing dumber than I am, could you show 
me hgow to start the formula you described in your earlier message?

Bob


On Wed, 5 Aug 2009 15:54:05 -0500, RUNION ROBERT  wrote: 
 
>Dennis - Is there anyway to use ACCESS to populate the burial address  
>to all those buried in a specific cemetery?  I find after viewing the  
>suggestions here that I have a lot of folks I know are buried in a  
>specific cemetery, but it would take a lot of key strokes to get this  
>data into my file if I can not do so via Access.  Please advise. 
 
Yes. It shouldn't be too difficult. Something like... 
 
UPDATE tblAR, tblIR SET tblIR.IDARBuried=[tblAR]![IDAR] WHERE 
((tblIR.IDARBuried=0) AND (tblIR.IDIR<>0) AND (tblIR.Tag1=1) AND 
(tblAR.AddrName="XYZ Cemetery")) 
 
... sets the Burial Address to XYZ Cemetery for anyone on Tag #1 who 
does not already have a Burial Address. This was done quick & dirty so 
it may require more testing. 
 
The usual caveat re backing up your database before doing anything in 
Access applies. ;-) 
 
-- 
 
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