Print Page | Close Window

AppendAsPerFieldPos.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=143
Printed Date: 19 Jan 2021 at 1:11am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: AppendAsPerFieldPos.mdb
Posted By: A.D. Tejpal
Subject: AppendAsPerFieldPos.mdb
Date Posted: 10 Jul 2008 at 1:55am
This sample db demonstrates append action from one table to another, using 
field positions (instead of field names).

The technique can be handy for a set of tables having large number of fields, 
where data types across the tables are similar but field names are not.

The main subroutine accepts five arguments (name of source table, name of target 
table, desired start column in source table, desired start column in target table and 
number of columns to be covered in the range).

Last three arguments are optional. If omitted, all columns (except the one for auto-
number field) get appended.

Download Access XP & 2K: http://www.rogersaccesslibrary.com/forum/uploads/37/AppendAsPerFieldPos.zip - uploads/37/AppendAsPerFieldPos.zip



-------------
--

Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com



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