Print Page | Close Window

UpdateImportSeekFind.mdb (intermediate)

Printed From: Roger's Access Library
Category: Roger's Access Library
Forum Name: Roger's Download Samples
Forum Description: A compendium of Microsoft Access 97 and 2000+ routines, each separated into its own sample database.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=225
Printed Date: 15 Aug 2020 at 4:54am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: UpdateImportSeekFind.mdb (intermediate)
Posted By: Roger Carlson
Subject: UpdateImportSeekFind.mdb (intermediate)
Date Posted: 15 Jul 2008 at 11:34pm

 
Please consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm - find out why here .
 

UpdateImportSeekFind.mdb

This sample illustrates how to programmatically update a table from a temp table. The scenerio is that there is a text file download which has already been imported into a temp table "ShoeImport". Each record has a code in the field TRNCOD which indicates whether the record should "A" add a new record, "U" update a record, "D" delete a record, or "R" skip the record. Additionally, if there is a "U" and no matching record exists, the record should be Added.

There are four variations in the indicated modules: SEEK method with no status, SEEK with status, FIND with status, and Direct from a text file. Go the module to see the code.

Download
Access 97 (224 KB):
http://www.rogersaccesslibrary.com/forum/uploads/5/UpdateImportSeekFind97.zip - uploads/5/UpdateImportSeekFind97.zip
Access 2000 DAO (238 KB): http://www.rogersaccesslibrary.com/forum/uploads/5/UpdateImportSeekFind2k.zip - uploads/5/UpdateImportSeekFind2k.zip


-------------
Consider donating $1 per sample downloaded, http://www.rogersaccesslibrary.com/whydonations.htm" rel="nofollow - find out why here .<



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net